Generate random numbers in between ranges in SQL Server

Generate the random number in between range SQL Server

---- Declare the variables 
DECLARE @Random INT;
DECLARE @Upper INT = 1;
DECLARE @Lower INT = 2000;
---- This will generate a random number between 1 and 2000
SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
SELECT @Random

Generate random number

---- random int from 0 to 50
SELECT round(50*RAND(),0)

-- random float number from 0 to 50
SELECT 50*RAND()

-- random float from 10 to 30 
SELECT 10 + (30-10)*RAND()

--random integer BETWEEN 0 and 20
SELECT CONVERT(INT, (20+1)*RAND())