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
Post a Comment