Export (0) Print
Expand All

CRYPT_GEN_RANDOM (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft