declare @a integer declare @b integer set @a=1 set @b=1 while @b<100 begin set @a=1 -------------->這裡加上這句話 while @a<100 begin insert into bomd(bomdGoods,bomdPgoods) values (@a,@b) set @a=@a+1 end set @b=@b+1 end
写成这样应该可以 declare @a integer declare @b integer set @a=1 set @b=1 while @b<100 and @a<100 begin insert into bomd(bomdGoods,bomdPgoods) values (@a,@b) set @a=@a+1 set @b=@b+1 end
declare @b integer
set @a=1
set @b=1
while @b<100
begin
set @a=1 -------------->這裡加上這句話
while @a<100
begin
insert into bomd(bomdGoods,bomdPgoods) values (@a,@b)
set @a=@a+1
end
set @b=@b+1
end
declare @a integer
declare @b integer
set @a=1
set @b=1
while @b<100 and @a<100
begin
insert into bomd(bomdGoods,bomdPgoods) values (@a,@b)
set @a=@a+1
set @b=@b+1
end