CodePaste.NET

   1:  DECLARE @RandomNumber float
   2:  DECLARE @RandomInteger int
   3:  DECLARE @MaxValue int
   4:  DECLARE @MinValue int
   5:   
   6:  SET @MaxValue = 4
   7:  SET @MinValue = 2
   8:   
   9:  SELECT @RandomNumber = RAND()
  10:   
  11:  SELECT @RandomInteger = ((@MaxValue + 1) - @MinValue) * @RandomNumber + @MinValue
  12:   
  13:  SELECT @RandomNumber as RandomNumber, @RandomInteger as RandomInteger