[MSSQL] 저장프로시저 FETCH 처리

FETCH처리를 하니 역시 속도는 떨어지는거 같다.

DROP PROC UP_TEST_001

GO

CREATE PROC UP_TEST_001

(

   @TEST VARCHAR(99)

)

AS

DECLARE @I_COUNT     INT = 0

BEGIN

    DECLARE @KEY_MAT_ID VARCHAR(90)

          , @MAT_ID     VARCHAR(90)

          , @QTY        INT

    

    DECLARE BOM_CURSOR CURSOR FOR

SELECT KEY_MAT_ID, MAT_ID, QTY 

 FROM MES_BOM_DEF 

WHERE KEY_MAT_ID = 'XXX'

 

    OPEN BOM_CURSOR

    

FETCH NEXT FROM BOM_CURSOR

INTO @KEY_MAT_ID, @MAT_ID, @QTY

   

WHILE @@FETCH_STATUS = 0

BEGIN

SELECT @KEY_MAT_ID, @MAT_ID, @QTY

   

FETCH NEXT FROM BOM_CURSOR

INTO @KEY_MAT_ID, @MAT_ID, @QTY

END

    

    CLOSE BOM_CURSOR

    DEALLOCATE BOM_CURSOR

    

END