34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE (
uNum NVARCHAR(20)
,pwd NVARCHAR(20)
)
INSERT INTO @t VALUES ('aaa','aaa')
INSERT INTO @t VALUES ('bbb','aaa')
INSERT INTO @t VALUES ('ccc','aaa')
SELECT *,HashBytes('MD5',pwd) AS md5
FROM @t
/*
uNum pwd md5
-------------------- -------------------- ----------------------------------
aaa aaa 0x74E164017D6499CC68E1F5E123CA4A62
bbb aaa 0x74E164017D6499CC68E1F5E123CA4A62
ccc aaa 0x74E164017D6499CC68E1F5E123CA4A62
*/
这样不行?
select HashBytes('MD5','seven')
0xBB3AEC0FDCDBC2974890F805C585D432