sql 循环处理查询到的结果集

方法一：游标

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