SQL Server gets the random number function rand () and rand (x)

--rand (x) returns a random floating-point value of V, in the range between 0~1 (that is, 0<=v<=1.0)

--If an integer parameter x is specified, it is used as the seed value, and the same seed number will produce a repeating sequence. If the same seed value calls the RAND function multiple times, it returns the same build value

Example: Select rand (), RAND (), Rand ();

Results: 0.664547768839536 0.0166045240927059 0.0892182701370623

--Rand () without parameters has a different value each time.

Select Rand (TEN), Rand (11);

Results: 0.713759689954247 0.713759689954247 0.713778322925506

--When Rand (x) has the same parameters, it produces the same random number, with different X-generated random values

SQL Server gets the random number function rand () and rand (x)