sha256 function in SQL Server

sql-server hash sha256 sha
setzamora picture setzamora · Mar 17, 2011 · Viewed 58.8k times · Source

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?

Answer

Soheil Bakhshi picture Soheil Bakhshi · Jul 9, 2013

SQL Server 2012 supports SHA2_256 and SHA2_512.

 SELECT HASHBYTES('SHA2_256','something')

Related questions

Calculate Hash or Checksum for a table in SQL Server

I'm trying to compute a checksum or a hash for an entire table in SQL Server 2008. The problem I'm running into is that the table contains an XML column datatype, which cannot be used by checksum and has to be …

Read More
Storing a SHA512 Password Hash in Database

In my ASP.NET web app I'm hashing my user passwords with SHA512. Despite much SO'ing and Googling I'm unclear how I should be storing them in the database (SQL2005) - the code below shows the basics of how I'm …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More