declare @ii int
set @ii=0while (@ii<10)
begin insert into aa (name) values (@ii)
set @ii=@ii+1
end
set @ii=0while (@ii<10)
begin insert into aa (name) values (@ii)
set @ii=@ii+1
end
调试欢乐多
set @ii=0
while (@ii<10)
begin
insert into aa (name) values (@ii)
set @ii=@ii+1
end
begin insert into aa (name) values (@ii)
select @ii=@ii+1
end