MD5 with t-sql
Filed in SQL on Jul.12, 2007
You can use HashBytes to achieve.
Check this for reference: http://msdn2.microsoft.com/en-us/library/ms174415.aspx
SELECT
HashBytes('MD5', 'Praveen'),
HashBytes('MD5', 'PraveeN'),
'0xD09C2ECC3DFCDC8C8D921B589097FCB1',
CASE WHEN convert(int,HashBytes('MD5', 'PraveeN')) = 0xD09C2ECC3DFCDC8C8D921B589097FCB1
THEN
'Success'
ELSE
'Failed'
END
Note: for MySQL you have MD5() function
Related posts:
