MSDN URL is belowing:
https://msdn.microsoft.com/zh-cn/library/ms174415.aspx
TSql HASHBYTES 用法
标签：
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