oracle循环插入大量数据:
declare
temp varchar(20):='aaaa';
i int;
begin
for i in 1..100 loop
insert into test(id,name) values(i,temp||i);
end loop;
end;
sqlserver循环插入大量数据
declare
@name varchar(20)='hcf';
declare
@phone varchar(20)='131';
declare
@i int=0;
while @i<10
begin
insert into student(sno,sname,sage,ssex,sdept,phone) values(@i,@name+convert(varchar(10),@i),31,'男','三年级',@phone+convert(varchar(10),@i));
set @i=@i+1
end;