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

Question

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?

Thanks,

Leo · Accepted Answer · 2010-11-26 04:40:49Z

1

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!

answered Nov 26, 2010 at 4:40

Leo

2,2237 gold badges29 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related