The MD5 function of MSSQLSERVER

Reference: Https://www.cnblogs.com/JuneZhang/p/6396896.html?utm_source=itdadao&utm_medium=referral

Brief description:

Encryption methods are: MD2 | MD4 | MD5 | SHA | SHA1

Select Hashbytes (' MD5 ', ' 12345678 ')-This return value starts with 0x and results in a binary type of varbinary, which is problematic for writing to the database varchar

The process is turned into a string:

Select substring (sys.fn_sqlvarbasetostr (hashbytes ('MD5','12345')), 3)--Remove the 0x from the front, the result is a string

The MD5 function of MSSQLSERVER