一般用wihledeclare @i int set @i=0while @i<100 begin .... set @i=@i+1 end来实现for循环
create proc p_test as declare @i int set @i=0 while @i<10 begin set @i=@i+1 end print @i
例如: DECLARE @I INT SET @I=1 WHILE @I<10 BEGIN SELECT @I SET @I=@I+1 END
SQL语言中没有for循环,可以用while
if object_id('P_text')is not null drop proc P_text go create proc P_text @i int as begin declare @t table(id int) while @i>0 insert @t values(@i) set @i=@i-1 end execute P_text 100
set @i=0while @i<100
begin
....
set @i=@i+1
end来实现for循环
as
declare @i int
set @i=0
while @i<10
begin
set @i=@i+1
end
print @i
DECLARE @I INT
SET @I=1
WHILE @I<10
BEGIN
SELECT @I
SET @I=@I+1
END
drop proc P_text
go
create proc P_text
@i int
as
begin
declare @t table(id int)
while @i>0
insert @t values(@i)
set @i=@i-1
end
execute P_text 100
begin
...
end