locked
How to show random number RRS feed

  • Question

  • User264732274 posted

    i use below script to show random number. so any other way exist to achieve the same. thanks

    DECLARE @UpperValue INT
    DECLARE @LowerValue INT
    
    SET @UpperValue = 10
    SET @LowerValue = 1
    
    SELECT ROUND(((@UpperValue - @LowerValue -1) * RAND() + @LowerValue), 0)

    Friday, November 25, 2016 2:52 PM

Answers

All replies