CRYPT_GEN_RANDOM (Transact-SQL)

CRYPT_GEN_RANDOM (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a cryptographic random number generated by the Crypto API (CAPI). The output is a hexadecimal number of the specified number of bytes.

Topic link icon Transact-SQL Syntax Conventions

  
CRYPT_GEN_RANDOM ( length [ , seed ] )   

length
The length of the number being created. Maximum is 8000. length is type int.

seed
Optional data to use as a random seed. There must be at least length bytes of data. seed is varbinary(8000).

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) ;  

RAND (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft