SoftadminUtil.Binary_Hash

Show allHide all
Not available in Cloud edition.
Type: Scalar function

Computes the hash of its input. Unlike the builtin HASHBYTES it can work on data longer than 8000 bytes and supports modern algorithms.

Parameters

@algorithm mandatory varchar(10)
What algorithm to use to compute the hash
Possible value Description
md5 Returns a binary(16) hash
sha1 Returns a binary(20) hash
sha256 Returns a binary(32) hash
sha512 Returns a binary(64) hash
@bytes mandatory varbinary(max)
Data to compute hash for