SQL Server/T-SQL/Math Functions/RAND

RAND: Generates a random number between 0 and 1, which is returned as a float

2> -- RAND: Generates a random number between 0 and 1, which is returned as a float.
3>
4> SELECT RAND()
5> GO
------------------------
     0.22527817133168881
(1 rows affected)