Morema
10/9/2018 - 8:44 AM

Random Range generator SQL

Generate random numbers in SQL

DECLARE	@maxRange INT = 15,
		@rangeStart INT = 1,
		@rangeEnd INT = 16 
SELECT
	CONVERT(INT, @rangeStart + RAND() * @maxRange),
	CONVERT(INT, @rangeEnd + RAND() * @maxRange)