How to Insert an Md5 Password in Mssql

byczetsuya -الثلاثاء, نوفمبر 08, 2011

1

To md5 a string in mssql we execute this query:

select HASHBYTES('MD5', 'password')

//But this has a problem because it returns a VarBinary data type which is a garbled text. So it should be converted first to NVarchar:
SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'password'),2)

//To insert in the database
insert into Users (username, password) values ('user', (SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'password'),2)))

1 تعليقات