HashBytes (Transact-SQL)
Returns the MD2, MD4, MD5, SHA, or SHA1 hash of its input.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
HashBytes ( '<algorithm>', { @input | 'input' } )
<algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1
Arguments
- '<algorithm>'
Identifies the hashing algorithm to be used to hash the input. This is a required argument with no default. The single quotation marks are required.
- @input
Specifies a variable containing the data to be hashed. @input is varchar, nvarchar, or varbinary.
- 'input'
Specifies a string to be hashed.
Return Value
varbinary (maximum 8000 bytes)
Examples
The following example returns the SHA1 hash of the nvarchar data stored in variable @HashThis.
DECLARE @HashThis nvarchar(max);
SELECT @HashThis = CONVERT(nvarchar,'dslfdkjLK85kldhnv$n000#knf');
SELECT HashBytes('SHA1', @HashThis);
GO
See Also
Other Resources
Choosing an Encryption Algorithm