游标-查询后序列值更新

declare @ClassID int
declare @I int
set @I=1
DECLARE cursor_Userid CURSOR FOR
SELECT FCampClassID
  FROM [t_Camp_Class]
where [FSchoolID]=1 and [FIsComplete]=0
order by FClassType asc, FSchoolYear desc ,replace(FClassName,'班','') asc

OPEN cursor_Userid
FETCH NEXT FROM cursor_Userid INTO  @ClassID

WHILE @@FETCH_STATUS = 0
BEGIN

  update [t_Camp_Class] set FOrder=@I  where FCampClassID=@ClassID
 
  set @I=@I + 1
   
  FETCH NEXT FROM cursor_Userid   INTO  @ClassID
  
  
END

CLOSE cursor_Userid
DEALLOCATE cursor_Userid