Author Archives: Tyler Clendenin

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

SQL Server 2000
xp_MD5 at http://www.codeproject.com/database/xp_md5.asp

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 http://www.codeproject.com/database/xp_md5.asp?df=100&forumid=32460&select=1519990#xx1519990xx

My Introduction

Hello there, this is my first blog at tylerclendenin.com.

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.