how to generate random numer in sql serer code example

Example: tsql random number

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