Returns a cryptographic random number generated by the Crypto API (CAPI). The output is a hexadecimal number of the specified number of bytes.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Transact-SQL Syntax Conventions
CRYPT_GEN_RANDOM ( length [ , seed ] )
The length of the number being created. Maximum is 8000. length is type int.
Optional data to use as a random seed. There must be at least length bytes of data. seed is varbinary(8000).
This function is public and does not require any special permissions.
A. Generating a random number
The following example generates a random number 50 bytes long.
SELECT CRYPT_GEN_RANDOM(50) ;
The following example generates a random number 4 bytes long using a 4-byte seed.
SELECT CRYPT_GEN_RANDOM(4, 0x25F18060) ;