SELECT RAND(22) Result : RAND « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. RAND
3>
4> SELECT RAND(22) Result
5> GO
Result
------------------------
     0.71398328560934576

(1 rows affected)








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