• 游标本次循环,跳过某些语句


    DECLARE @Name NVARCHAR(50),@NRIC NVARCHAR(15),@PersonID INT
    DECLARE CUR_Test1 CURSOR FOR
    SELECT [Name],NRIC,PersonID FROM tblCtcPersonTest1
    OPEN CUR_Test1
    FETCH NEXT FROM CUR_Test1 INTO @Name,@NRIC,@PersonID;
     WHILE @@FETCH_STATUS =0
        BEGIN

            IF    EXISTS(SELECT * FROM tblCtcPersonTest WHERE NRIC=@NRIC )
            BEGIN
                  GOTO UPDATE_IMPORT_RESULT;
            END

            UPDATE tblCtcPersonTest SET Flag='not Go To' WHERE PersonID=@PersonID

            IF CHARINDEX('*',@NRIC)>0
            BEGIN
                INSERT INTO tblCtcPersonTest([Name],[PersonID],NRIC)VALUES(@Name,@PersonID,@NRIC)
            END
            ELSE
            BEGIN
                 UPDATE tblCtcPersonTest1 SET Remarks='cant insert' WHERE PersonID=@PersonID
                
            END
            UPDATE_IMPORT_RESULT:
            UPDATE tblCtcPersonTest SET Remarks='Go To' WHERE PersonID=@PersonID
        FORNEXT:
        FETCH NEXT FROM CUR_Test1 INTO @Name,@NRIC,@PersonID;
        END
    CLOSE CUR_Test1;
    DEALLOCATE CUR_Test1

  • 相关阅读:
    手动安装mysql-5.0.45.tar.gz
    Hadoop2.5.2+HA+zookeeper3.4.6详细配置过程
    大数据分析之技术框架整理
    docker安装
    CentOS 6.8安装Docker V1.0
    处理百万级的数据
    剑指 Offer 32
    剑指 Offer 32
    剑指 Offer 32
    剑指 Offer 31. 栈的压入、弹出序列
  • 原文地址:https://www.cnblogs.com/TieJing/p/11434641.html
Copyright © 2020-2023  润新知