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
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.