MS SqlServer 2008R2- Sql语句循环遍历生成百条随机数
Sql语句,循环遍历生成区间5~20的随机数语句如下:
are @i int DECLARE @Result INT DECLARE @Upper INT DECLARE @Lower INT SET @Lower = 5 SET @Upper = 20 SELECT @Result = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) SELECT @Result set @i = 0 while @i < 369 begin insert into master.dbo.test_1(num) select ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) SET @i = @i + 1 end

浙公网安备 33010602011771号