create procedure test
as
declare @a int
declare @b int
select @a=1
select @b=1
while (@a<101)
begin
while (@b<101)
begin
@b=@b+1
end
@a=@a+1
end
GO
as
declare @a int
declare @b int
select @a=1
select @b=1
while (@a<101)
begin
while (@b<101)
begin
@b=@b+1
end
@a=@a+1
end
GO
as
declare @a int
declare @b int
while @a<=100
begin
while @b<=100
begin
.....
set @b=@b+1
end
...
@a=@a+1
end
GO
as
declare @a int
declare @b int
select @a=1
while (@a<101)
begin
select @b=1
while (@b<101)
begin
@b=@b+1
end
@a=@a+1
end
GO
as
declare @a int
declare @b int
set @a=1
set @b=1
while (@a<101)
begin
while (@b<101)
begin
set @b=@b+1
end
set @a=@a+1
end
GO
as
declare @a int
declare @b int
set @a=1
while (@a<101)
begin
set @b=1
while (@b<101)
begin
set @b=@b+1
end
set @a=@a+1
end
GO
as
declare @a int
declare @b int
select @a=1
select @b=1
while (@a<101)
begin
while (@b<101)
begin
@b=@b+1
end
@a=@a+1
end
GO