方法一:游标
DECLARE
@id INT
BEGIN
DECLARE c_test CURSOR FAST_FORWARD FOR
SELECT id FROM [数据表];
OPEN c_test;
WHILE 1=1
BEGIN
FETCH NEXT FROM c_test INTO @id;
IF @@fetch_status!= 0 BREAK;
select @id
END;
CLOSE c_test
DEALLOCATE c_test
END;
方法二:while
Declare @i int
Select @i=Min(id) from [数据表]
While @i Is Not Null
Begin
select @i
Select @i=Min(id) from [数据表] Where id>@I
End