Random Number Generation in SQL Server

Question

I Need to generate a random number between two numbers for each row.

For Eg:

select ColName,(Random nos between 1500 to 2000) from TableName

Thanks in advance

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

DECLARE @start INT
DECLARE @end INT

SET @start = 1500
SET @end = 2000

SELECT  Round(( ( @end - @start - 1 ) * Rand() + @start ), 0)

Update : To get random number for each row.

select ABS(Checksum(NewID()) % (@end-@start)) + @start

Random Number Generation in SQL Server

Sign up