游标的简单使用

DECLARE @ReportStyle INT,
        @AddUpItemID INT,
     @AddUpItemStyleSystemID INT,
     @OutputPositionDivision INT ,
     @AddUpItemStyleID INT,
     @Sign INT
SET @AddUpItemID=@AddUpItemIDS
SET @Sign=@SignS
DECLARE mycursor CURSOR FAST_FORWARD FOR
  SELECT AddUpItemStyleSystemID,OutputPositionDivision,AddUpItemStyleID
  FROM T_tbMA_AddUpItemStyle
  WHERE AddUpItemID=@AddUpItemID AND ColOutputInfoStyle=0
FOR READ ONLY
OPEN mycursor
FETCH NEXT FROM mycursor INTO @AddUpItemStyleSystemID,@OutputPositionDivision,@AddUpItemStyleID
 WHILE (@@FETCH_STATUS = 0)
  BEGIN
            SET @ReportStyle=(SELECT ReportOutputStyle FROM T_tbMA_AddUpItemStyleSystem
            WHERE AddUpItemStyleSystemID=@AddUpItemStyleSystemID)
            IF @ReportStyle=0
    BEGIN
      IF @Sign=1
      UPDATE T_tbMA_AddUpItemStyle SET AddUpDivision=3,ReferencePeriodDivision=3
      WHERE AddUpItemStyleID=@AddUpItemStyleID
    END
            ELSE
                BEGIN
     IF @OutputPositionDivision=0 OR @OutputPositionDivision=2
           BEGIN
         IF @Sign=1
          UPDATE T_tbMA_AddUpItemStyle SET ReferencePeriodDivision=2
             WHERE AddUpItemStyleID=@AddUpItemStyleID
           END
     ELSE
           BEGIN
      IF @Sign=1
       UPDATE T_tbMA_AddUpItemStyle SET ReferencePeriodDivision=2
          WHERE AddUpItemStyleID=@AddUpItemStyleID
           END
    END
   FETCH NEXT FROM mycursor INTO @AddUpItemStyleSystemID,@OutputPositionDivision,@AddUpItemStyleID
     END
CLOSE mycursor
DEALLOCATE mycursor