HASHBYTES#
Returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of its input.
Syntax#
HASHBYTES ( '<algorithm>', { @input | 'input' } )
<algorithm>::= MD5 | SHA | SHA1 | SHA2_256 | SHA2_512
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. Note that deprecated algorithms MD2 and MD4 supported by SQL Server are not supported by Querona.
@input
Specifies a variable containing the data to be hashed. @input is varchar, nvarchar, or varbinary.
‘input’
Specifies an expression that evaluates to a character or binary string to be hashed.
The output conforms to the algorithm standard: 128 bits (16 bytes) for MD2, MD4, and MD5; 160 bits (20 bytes) for SHA and SHA1; 256 bits (32 bytes) for SHA2_256, and 512 bits (64 bytes) for SHA2_512.
Return types#
varbinary (maximum 2000 bytes)
The length of return varbinary value differes from the original MS SQL Server implementation of 8000 bytes due to compatibility reasons with other database engines like Oracle.
Example#
SELECT HASHBYTES('SHA2_256', 0x4234123412341234);