DECLARE @CARDCODE AS NVARCHAR
DECLARE OCRD1 CURSOR 
FOR
SELECT cardname from ocrd
OPEN OCRD1
FETCH OCRD1 INTO @CARDCODE
WHILE @@FETCH_STATUS=0
BEGIN
UPDATE ANOTHERDB.dbo.OCRD
SET cardname=@cardname
where cardcode=@CARDCODE
FETCH OCRD1 into @CARDCODE
END
CLOSE OCRD1