开发者

SQL How can I convert MD5 Hash String to Binary using query?

开发者 https://www.devze.com 2023-01-26 19:52 出处:网络
In my project, I have a user table where password is MD5 hashed and stored as binary(16). Now I want to write those user data as INSERT queries to a .sql file so that customer can import them back aga

In my project, I have a user table where password is MD5 hashed and stored as binary(16). Now I want to write those user data as INSERT queries to a .sql file so that customer can import them back again?

Or is there anyway to export those data directly? I tried DTS using from Excel to Access file but when importing, there are several errors occur that I don't know why? Or is there any other tool besides MSSQL Server that can do this?

So far, now I'm using detach/attach the whole database to send to the customer which I think is not really a good way?

T开发者_C百科hanks,


Someone posted an answer to my question and deleted it right away? He suggested me to use HASHBYTES which is exactly what I'm looking for. Thanks!

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号