A short script to generate a random integer between 1 and a specified upper bound (5 in this example):

declare @UpperBound int = 5
select ceiling((rand() * @UpperBound))