sql游标应用

  

  DECLARE @DEPT_NO VARCHAR(12)
   DECLARE @SYS_ID  INT
   DECLARE fCUR CURSOR FOR SELECT DEPT_NO  FROM  DEPT
   OPEN fCUR
   FETCH NEXT FROM fCUR INTO @DEPT_NO
   WHILE @@FETCH_STATUS = 0
      BEGIN

           DECLARE @IP INT
           SET @IP =0
           DECLARE F_RR CURSOR FOR  SELECT SYS_ID FROM TEL WHERE DEPT_NO=@DEPT_NO
           OPEN F_RR
           FETCH NEXT FROM F_RR INTO @SYS_ID
           WHILE @@FETCH_STATUS = 0
             BEGIN
               set @IP=@IP+1
               UPDATE TEL SET SYS_NO =@IP WHERE SYS_ID=@SYS_ID
               FETCH NEXT FROM F_RR INTO @SYS_ID
             END  
           CLOSE F_RR
           DEALLOCATE F_RR

         FETCH NEXT FROM fCUR INTO @DEPT_NO
      END
   CLOSE fCUR
   DEALLOCATE fCUR