how to use function to generate rand number in mssql server?

Question

Amit Singh · Answer

we use rand function in sql server to generate random number
* RAND(seed) - Starting a new sequence of random numbers based on the given integer "seed" and returning the first random number in FLOAT(53) from the sequence.
* RAND() - Returning the next random number in FLOAT(53) from the current sequence. If there has been no current sequence, SQL Server will start a new sequence with a random "seed".
for example:
SELECT RAND(100);

interview

how to use function to generate rand number in mssql server?

Can you answer this question?

1 Answers