t-sql random number for each row code example

Example 1: tsql random number

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

Example 2: t-sql random number for each row

ABS(CHECKSUM(NewId())) % 14