shikarishambu shikarishambu - 1 year ago 187
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


Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download