SQL SERVER中直接循环写入数据


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

Published At
Categories with 数据库类
comments powered by Disqus