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!
精彩评论