Generate random number

랜덤번호생성

DECLARE @RangeStart INT

DECLARE @RangeEnd   INT

    SET @RangeStart = 1000

    SET @RangeEnd   = 9999

 SELECT CAST(FLOOR(RAND(CAST(NEWID() AS VARBINARY))*(@RangeEnd-@RangeStart+1)+@RangeStart) AS INT)