RAND Returns random number from 0 to 1. : RAND « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. RAND
4>
5>
6> select CEILING(RAND()*100)
7> GO

------------------------
                      51

(1 rows affected)
1>








11.17.RAND
11.17.1.RAND Generates a random number between 0 and 1, which is returned as a float.
11.17.2.RAND Returns random number from 0 to 1.
11.17.3.select RAND()
11.17.4.SELECT RAND(22) Result