To genereate a random number in SQL Server we can use random function. Check example below where a random generated number is between 1 and 100:
select rand() select rand() * 100 select cast(rand() * 100 as int) as number