Let’s say, I need a random number within a specific range, how do I do that?
Here’s the code that will do it:
|
1 2 3 4 5 6 7 8 9 |
1> DECLARE @i_min int 2> DECLARE @i_max int 3> SELECT @i_min = 0 4> SELECT @i_max = 10 5> SELECT MY_RANDOM_NUMBER = ROUND(((@i_max - @i_min) * RAND() + @i_min), 0) 6> go MY_RANDOM_NUMBER -------------------- 7.000000 |