How to Insert an Md5 Password in Mssql
To md5 a string in mssql we execute this query: select HASHBYTES('MD5', 'password') //But this has a problem because it re...
https://www.czetsuyatech.com/2021/07/mssql-insert-md5-password.html
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 comment
Thanks it was helpful
Post a Comment