开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜