应该是:
declare @i int,@counter int,@id int
set @i=1
set @counter=4
while @i<=@counter
begin
select @id=@i,
@i=@i+1
end
declare @i int,@counter int,@id int
set @i=1
set @counter=4
while @i<=@counter
begin
select @id=@i,
@i=@i+1
end
set @i=1
set @counter=4
while @i<=@counter
begin
select @id=@i,
@i=@i+1
end
1.为什么要用逗号分开,同样是赋值,在循环外就不要
2.把select @id=@i换成
set @id=@i就不行了