cursor3
public sql v1 · immutableDECLARE @CARDCODE AS NVARCHARDECLARE OCRD1 CURSOR FORSELECT * from z_dtw_queueOPEN OCRD1FETCH OCRD1 INTO @CARDCODEWHILE @@FETCH_STATUS=0BEGINUPDATE OCRDSET U_STOXOS=@CARDCODEFETCH OCRD1 into @CARDCODEENDCLOSE OCRD1DECLARE @CARDCODE AS NVARCHARDECLARE OCRD1 CURSOR FORSELECT * from z_dtw_queueOPEN OCRD1FETCH OCRD1 INTO @CARDCODEWHILE @@FETCH_STATUS=0BEGINUPDATE OCRDSET U_STOXOS=@CARDCODEFETCH OCRD1 into @CARDCODEENDCLOSE OCRD1