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> 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