sql - Getting Error while run function MD5 -


my function:

declare @data varchar(50) = 'rushang' declare @hash char(32)     set @data = 'micro' + @data exec master.dbo.xp_md5 @data, -1, @hash output select substring(@hash,5,17) 

error:

msg 17750, level 16, state 0, procedure xp_md5, line 1
not load dll xp_md5.dll, or 1 of dlls references. reason: 193(%1 not valid win32 application.).

(1 row(s) affected)

result:-

null

for 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


Comments

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -