Random integer number in Transact-SQL (Microsoft SQL Server)

random-int.sql

/*
Slow method

Pre-use my integer's table: https://gist.github.com/dm-logv/38eb66f5a2a461cb8f42e14714682daa
*/
SELECT TOP 1 i
FROM #integers
ORDER BY NEWID();


/*
Mid-fast method

Range [0; @max)
*/
DECLARE @max INT = 1000000; 
SELECT ABS(CHECKSUM(NEWID())) % @max;