t-sql random number for each row
snippet in sql

tsql random number

user6040

SELECT FLOOR(RAND()*(b-a+1))+a;

t-sql random number for each row

user9398

ABS(CHECKSUM(NewId())) % 14