MSDN URL is belowing:
https://msdn.microsoft测试数据/zh-cn/library/ms174415.aspx
TSql HASHBYTES 用法
标签：
查看更多关于TSql HASHBYTES 用法的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did160953
TSql HASHBYTES 用法
TABLE [ dbo ] . [ test ]
(
[ code ] [ int ] NULL ,
[ name ] [ varchar ] ( 10 ) NULL ,
[ txt ] [ nvarchar ] ( 10 ) NULL
)
insert into dbo.test(code)
values ( 1 )
print HASHBYTES( ‘ MD5 ‘ , ‘ 1 ‘ )
-- 0xC4CA4238A0B923820DCC509A6F75849B
select *
from dbo.test
where HASHBYTES( ‘ MD5 ‘ , cast (code as varchar )) = 0xC4CA4238A0B923820DCC509A6F75849B
阅读：31次