Laboratory/MSSQL

HashBytes(Transact-SQL)

theking 2011. 6. 28. 11:40

출처 : http://msdn.microsoft.com/ko-kr/library/ms174415.aspx



DECLARE @HashThis nvarchar(4000);

SELECT @HashThis = CONVERT(nvarchar(4000),'Passw0rd');

SELECT HashBytes('MD5', @HashThis);

 

/********************************************

HashBytes ( '<algorithm>', { @input | 'input' } )

<algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1

********************************************/