Dupa exemplul lor
DECLARE @HashThis nvarchar(max);
SELECT @HashThis = CONVERT(nvarchar,'dslfdkjLK85kldhnv$n000#knf');
SELECT HashBytes('SHA1', @HashThis);
Apar urmatoarele rezultate:
--SHA1
--0x61E00587A759D7009F4C3A46C14E32FD3E11FB43
--SHA
--0x61E00587A759D7009F4C3A46C14E32FD3E11FB43
--MD5
--0x8FE2945A258B416B9F98D424E69DAE23
--MD4
--0xB9F6E8D0C1CD6B78CE79BF0CD099C60C
--MD2
--0xC93EE95343C6D0A002AF80B94503E6AF
iar
DECLARE @HashThis nvarchar(max);
SELECT @HashThis = CONVERT(nvarchar,'Gigi');
SELECT HashBytes('SHA1', @HashThis);
--SHA1
0x78E63717D95939ED46C5347E9DAC9CBEF2D6B29F
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)