sha256 function in SQL Server

Question

Is there a built-in sha256 function in SQL Server? I can't find a sha256 T-SQL function source code either. Anyone who has an alternative?

Solution 1

SQL Server 2012 supports SHA2_256 and SHA2_512.

 SELECT HASHBYTES('SHA2_256','something')

Solution 2

I think you are looking for HASHBYTES, but it supports only up to SHA-1 (160 bytes)

FYI Hashing is not encrypting. It is irreversible. Encryption is a process that is reversible to get the original data.

Reference for SHA2

SHA-2 is a set of cryptographic hash functions (SHA-224, SHA-256, SHA-384, SHA-512)

---

discussion

As for 256-byte hashing function - there isn't one built in.

Comments

[setzamora]

yes, it's for hashing random salt + password

[setzamora]

it doesn't support sha256 yet.