Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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