توليد الارقام عشوائية

DECLARE @Num int,

DECLARE @First int,

DECLARE @Last int



set @First = 1000

set @last = 9999



SELECT @Num = ROUND(((@First - @Last - 1) * RAND() + @Last), 0)

SELECT @Num

DECLARE @Num int;
DECLARE @FirstNum int;
DECLARE @LastNum int




set @FirstNum = 1000
set @LastNum = 9999




SELECT @Num = ROUND(((@FirstNum - @LastNum - 1) * RAND() + @LastNum), 0)
SELECT @Num