Anastasiosyal.com

Hi and welcome to my blog. Im Tasos, a software engineer working in the UK. This is where i share some of my findings related with SQL, c#, asp.net and javascript with you. I hope you find something helpful and Im looking forward to your feedback!

Popular Posts

• 4 Features for C# 4.0
• Beyond SoundEx - Functions for Fuzzy Searching in MS SQL Server
• Expose your objects over HTTP with minimal coding
• Quick Tip: Use Hashbytes to create a Hash in TSQL in SQL Server
• Regular Expressions In MS SQL Server using CLR
• Disable Text Wrapping in Excel Export of Reporting Services
• How to Script the data of an SQL table using a Stored proc
• Making your ASP:Repeater a little bit DRYer
• C# 3.0 Anonymous type support is incomplete
• SQL Server script to auto-create indexes on all Foreign Key Columns

April 2008 Entries

Quick Tip: Use Hashbytes to create a Hash in TSQL in SQL Server

posted @ Wednesday, April 23, 2008 8:03 PM | Feedback (10),

Just a quick tip.
I was unaware until recently that SQL Server 2005 has nicely built in support for hashing and it is called hashbytes

HashBytes ( '<algorithm>', { @input | 'input' } )
<algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1

Parameters are the algorithm you wish to hash to and the input string to hash.
Here is a sample along with the return values commented in the next line:

Select HashBytes('MD2', 'Hello world!') 
--0x63503D3117AD33F941D20F57144ECE64

Select HashBytes('MD4', 'Hello world!') 
--0x0D7A9DB5A3BED4AE5738EE6D1909649C

Select HashBytes('MD5', 'Hello world!') 
--0x86FB269D190D2C85F6E0468CECA42A20

Select HashBytes('SHA', 'Hello world!') 
--0xD3486AE9136E7856BC42212385EA797094475802

Select HashBytes('SHA1', 'Hello world!') 
--0xD3486AE9136E7856BC42212385EA797094475802

MSDN: http://msdn2.microsoft.com/en-us/library/ms174415.aspx