Using the HASHBYTES Function in SQL

The HASHBYTES?function returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of a string. The next example returns a SHA1 hash value of it the string that was input.

DECLARE @Hash nvarchar(4000);SET @Hash = CONVERT(nvarchar(4000),'abcdefghijklmnopqrstuvwxyz1234567890');SELECT HASHBYTES('SHA1', @Hash);

The SHA1 hash value is:



Visit the DevX Tip Bank


Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: