SQL RAND() Function
RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
The RAND function will return a repeatable sequence of random numbers each time a particular seed value is used.
For more articles, kindly visit to www.SQLServerLog.com