请问這個语法那有错呢

[langeann]

请问下面语法那有错呢？一直跑不出来，讯息说倒数第二行@i处有错…
declare @i int
declare @m int
set @i=1
set @m=20
while @i <=@m
begin
select m1.id from m1 where id_no=@i
@i = @i +1
end

[chuifengde]

set @i=@i+1

[青锋-SS]

select @i=@i+1

[kk19840210]

@i = @i +1

应该

set @i = @i +1

select @i = @i +1

[青锋-SS]

快了3秒

[dawugui]

declare @i int
declare @m int
set @i=1
set @m=20
while @i <=@m
begin
select m1.id from m1 where id_no=@i
set @i = @i +1
end

[wzy_love_sly]

declare @i int
declare @m int
set @i=1
select @m=count(*) from m1
while @i <=@m
begin
select m1.id from m1 where id_no=@i
set @i = @i +1
end

[langeann]

谢谢各位大大!