sha256 function in SQL Server [duplicate]

This question already has answers here: SHA256 in T-sql stored procedure (3 answers) Closed 9 years ago. 开发者_如何转开发

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?

---

SQL Server 2012 supports SHA2_256 and SHA2_512.

 SELECT HASHBYTES('SHA2_256','something')

---

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)

---

Here is a discussion about adding a salt to hashes

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