generate a random number in SQL Server RAND()
How to generate a random number in SQL Server
If you want to generate a random number in SQL Server you can use RAND() builtin function.
1.) SELECT RAND()
2.) SELECT CAST(RAND() * 250 AS INT)
The first line of code will simply generate a random number, the second line of code will generate a number between 1 and 250.