ADMIN_HashBytes

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

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