游标的简单使用

最新推荐文章于 2024-06-28 22:11:31 发布

zhutingjun

最新推荐文章于 2024-06-28 22:11:31 发布

阅读量286

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/zhutingjun/article/details/4206702

版权

SQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

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