Cursor

커서 사용 예시

 

 

DECLARE @a VARCHAR(50)
    ,   @b NVARCHAR(30)
    ,   @c NVARCHAR(30) 
    ,   @d NVARCHAR(30)   

 

--커서 생성

DECLARE CURS CURSOR
FOR SELECT
            a
        ,   b
        ,   c
        ,   d
        FROM #TEMP_EXCEL

 

--반복시작

OPEN CURS
FETCH NEXT FROM CURS INTO @a, @b, @c, @d
WHILE @@FETCH_STATUS=0
BEGIN

 

    --실행문
    IF @INOUT_GB <> ''
    BEGIN
        SET @STD_ITEM_NO = ''       
       
        UPDATE #TEMP_EXCEL
        SET a = @a
        WHERE a = @a
        AND b = @b
        AND c = @c
        AND d = @d
    END

    --실행문

    FETCH NEXT FROM CURS INTO @a, @b, @c, @d
END
CLOSE CURS
DEALLOCATE CURS