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?

See the answer here on SO: http://stackoverflow.com/questions/2954784/sha256-in-t-sql-stored-procedure — Simon Mourier, Mar 17 '11 at 07:41
Refer https://stackoverflow.com/questions/33021992/i-want-to-get-hexadecimal-value-off-a-binary-value-removing-0x-from-it — LCJ, Dec 26 '22 at 02:07

score 45 · Answer 1 · edited May 17 '14 at 18:16

45

SQL Server 2012 supports SHA2_256 and SHA2_512.

 SELECT HASHBYTES('SHA2_256','something')

edited May 17 '14 at 18:16

Jacob Parker

answered Jul 09 '13 at 00:58

Soheil Bakhshi

score 3 · Answer 2 · answered Mar 17 '11 at 06:57

3

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.

answered Mar 17 '11 at 06:57

RichardTheKiwi

2 Answers2