游标循环中定义变量

CREATE TABLE #temp (NAME VARCHAR(50));
INSERT INTO #temp VALUES ('1');
INSERT INTO #temp VALUES ('2');

DECLARE @i INT = 1;

DECLARE @djbh VARCHAR(50);
DECLARE A_CR CURSOR FORWARD_ONLY FOR SELECT NAME FROM #temp;
OPEN A_CR;
FETCH NEXT FROM A_CR
INTO @djbh;
WHILE @@fetch_status = 0
    BEGIN
        DECLARE @newremark VARCHAR(500);
        IF (@i = 1)
            BEGIN
                SET @newremark = 'ddddddd';
            END;
        SELECT @newremark;
        SET @i = @i + 1;
        FETCH NEXT FROM A_CR
        INTO @djbh;
    END;
--关闭游标
CLOSE A_CR;
DEALLOCATE A_CR;