HMACString

Computes the MD5, RIPEMD160, SHA1, SHA256, SHA384, or SHA512 Hash-based Message Authentication (HMAC) of a string input in SQL Server

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017



Syntax:

SELECT SQLHTTP.net.HMACString ( @Algorithm, @StringToHash, @HashKey )



Arguments:

Name	Type	Description
@Algorithm	varchar(20)	One of the following Algorithms: MD5, RIPEMD160, SHA1, SHA256, SHA384, or SHA512
@StringToHash	varchar(MAX)	string data to hash
@HashKey	varchar(MAX)	The key to use in the hash algorithm



Return Type:

varbinary(MAX)



Remarks:

We provide two distinct functions: HMACBinary and HMACString



Sample Usage:


DECLARE @Algorithm varchar(20)
DECLARE @StringToHash varchar(MAX)
DECLARE @HashKey varchar(MAX)

SET @Algorithm = 'MD5'

SET @StringToHash = 'The quick brown fox jumps over the lazy dog'

SET @HashKey = 'Secret Key or passphrase'

SELECT SQLHTTP.net.HMACString(@Algorithm, @StringToHash, @HashKey)

DECLARE @Algorithm varchar(20)

DECLARE @StringToHash varchar(MAX)

DECLARE @HashKey varchar(MAX)

SET @Algorithm = 'MD5'

SET @StringToHash = 'The quick brown fox jumps over the lazy dog'

SET @HashKey = 'Secret Key or passphrase'

SELECT SQLHTTP.net.HMACString(@Algorithm, @StringToHash, @HashKey)

--------------------------------------------------

0x0215902C5DF4F804CE5FEB4371F90541



HMACString

Featured API Wrapper Code / SQL Server