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)