ms sql 커서

DECLARE @CNT INT DECLARE @ATCL_NO INT,@CMP_ID NVARCHAR(20), @PSN_ID NVARCHAR(20), @DEPT_NAME NVARCHAR(100) DECLARE MYCUR CURSOR FOR SELECT BA.ATCL_NO, MJ.CMP_ID, MJ.PSN_ID, D.DEPT_NAME FROM BRD_ARTICLE BA, MY_JOB MJ, DEPARTMENT D WHERE BA.REG_EMP_ID = MJ.EMP_ID AND MJ.DEPT_ID = D.DEPT_ID OPEN MYCUR FETCH NEXT FROM MYCUR INTO @ATCL_NO ,@CMP_ID , @PSN_ID , @DEPT_NAME WHILE (@@FETCH_STATUS=0) BEGIN BEGIN UPDATE BRD_ARTICLE SET REG_PSN_ID=@PSN_ID ,REG_CMP_ID=@CMP_ID ,REG_DEPT_NAME = @DEPT_NAME WHERE ATCL_NO= @ATCL_NO END FETCH NEXT FROM MYCUR INTO @ATCL_NO ,@CMP_ID , @PSN_ID , @DEPT_NAME END CLOSE MYCUR DEALLOCATE MYCUR