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 

 

posted @ 2017-02-21 20:41  一品茗剑客  阅读(846)  评论(0)    收藏  举报