SQL Server Forums

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

sha 256

New Topic

Author

Topic

pnpsql
Posting Yak Master

India
241 Posts

Posted - 05/09/2012 : 08:51:39

how to implement sha 256 in sql server

challenge everything

TG
Flowing Fount of Yak Knowledge

USA
5467 Posts

Posted - 05/09/2012 : 09:21:28

select hashbytes('sha2_256', <valueToHash>)

I think as of sql 2008 r2 only SHA1 is available.
Check out:
http://msdn.microsoft.com/en-us/library/ms174415%28v=sql.105%29.aspx

Be One with the Optimizer
TG

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts

Posted - 05/09/2012 : 09:21:29

There is the HASH_BYTES function in T-SQL http://msdn.microsoft.com/en-us/library/ms174415.aspx Would that work for you?

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 05/09/2012 : 09:31:35

SHA256 is supported in HASHBYTES() in SQL 2012, for earlier versions you'd need to use a CLR function.

pnpsql
Posting Yak Master

India
241 Posts

Posted - 05/10/2012 : 01:12:08

any link for sha256 in clr

challenge everything

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 05/10/2012 : 08:14:43

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.