CREATE PROCEDURE test
AS
declare @v_i numeric
begin
select @v_i=1
while @v_i< 1000000
begin
insert into qbsource1(name) values('qb')
select @v_i=@v_i+1
end
end
AS
declare @v_i numeric
begin
select @v_i=1
while @v_i< 1000000
begin
insert into qbsource1(name) values('qb')
select @v_i=@v_i+1
end
end