How to get a random number from 1 to N in SQL Server

If you want to pick a random number from a range for example 1 to 1000 in SQL, you can use the RAND() that returns a pseudo-random float value plus the NEWID() function which creates a unique value of type uniqueidentifier. Here is a short SQL sniffet that picks a random number from 1 to 1000.

DECLARE @RandomNum int
SET @RandomNum = CONVERT(int, 1 + 1000*RAND(CHECKSUM(NEWID())))
PRINT @RandomNum

For more SQL Coding Tips, subscribe now.