Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

CRYPT_GEN_RANDOM (Transact-SQL)

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) ;
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.