SQL SERVER中直接循环写入数据

declare @i int
set @i =1
while @i<30
begin
insert into test(userid)values(@i)
set @i = @i+1
end

原文地址:https://www.cnblogs.com/wuhuisheng/p/1780721.html