RAND (TSQL Function)

Returns a pseudo-random float value, in the range [0, 1[.

Syntax

RAND ( )

Return Types

Returns float.

Remarks

RSQL doesn’t implement the RAND ( [ seed ] ) form, which is available in MS SQL Server.

Examples

PRINT RAND(), RAND(), RAND();

The result is:

      0.337948745855657|      0.941446323407677|      0.977709407663754|

but your result will not be the same.