xp_md5.dll for 64-bit
I am right now using this extended stored procedure in one of the test data开发者_StackOverflow中文版base on sql server 2008 and it works fine. I tried to do the same on a different sql server and it did not work on that. Then I got an explaination that the former was a 32 bit processor and latter was a 64 bit processor. Is there anyway to make use of this extended stored procedure on a 64-bit processor!!!
I need recompile version of xp_md5.dll for 64-bit.
Thanks in advance
If you want an MD5 why not use 2008's built in HASHBYTES()
?
DECLARE @IN NVARCHAR(4000) = N'Hello'
DECLARE @OUT VARBINARY(16)
SET @OUT = HASHBYTES('MD5', @IN)
SELECT @OUT
精彩评论