final

DECLARE @CARDCODE AS NVARCHARDECLARE OCRD1 CURSOR FORSELECT cardname from ocrdOPEN OCRD1FETCH OCRD1 INTO @CARDCODEWHILE @@FETCH_STATUS=0BEGINUPDATE ANOTHERDB.dbo.OCRDSET cardname=@cardnamewhere cardcode=@CARDCODEFETCH OCRD1 into @CARDCODEENDCLOSE OCRD1