Generate Random Numeric in sql server

 DECLARE @intFlag INT
declare @rand numeric(18,0)
Set @intFlag = 1

WHILE (@intFlag <=1000)
BEGIN
select @rand= convert(numeric(12,0),rand() * 89999999) + 10000000SET @intFlag = @intFlag + 1
print @rand
END


Result-