Category Archives: Uncategorized

MD5 Hash in SQL Server 2000 and 2005, 32 bit and 64 bit

SQL Server 2000
xp_MD5 at

Also works in SQL Server 2005 32 bit

SQL Server 2005

DECLARE @Data varchar(MAX)
SubString(master.dbo.fn_varbintohexstr(HashBytes('MD5', @Data)), 3, 32)

Works in SQL Server 2005 32 and 64 bit

Solution found at

My Introduction

Hello there, this is my first blog at

To start let me tell you a little about myself.

What do I hope to accomplish with this blog you ask?

  • To become a part of the global blog community.
  • To have a place on the internet that not only represents my views but also challenges other to think more about the world around them.
  • To write articles describing things that I have to overcome that I could not find another resource on the internet to help me. Maybe I can help someone else in that regard.