shikarishambu shikarishambu - 26 days ago 13
SQL Question

SQL Server 2008 R2 HASHBYTES SHA2 returns null

I am trying to use HASHBYTES with SHA2_512 as the algo. However when I try to do it in SQL Server Management Studio all that I get is null.

SELECT HASHBYTES('SHA1','test') //works
SELECT HASHBYTES('SHA2','test') //returns null


What am I doing wrong?

Is there a way to view the return value from
SELECT HASHBYTES('SHA2', 'test')
?

thanks

Answer

SQL Server supports SHA2 512 in SQL Server 2012+.

SQL Server 2008 R2 and below do NOT support SHA2_512. Here's HASHBYTES on MSDN.

Comments