sql链表更新

2019独角兽企业重金招聘Python工程师标准>>>

UPDATE  a
SET         cCusName=b.cCusName
FROM    ErpFZdata.dbo.Customer a
              INNER JOIN UFDATA_010.dbo.Customer b 
             ON b.cCusCode = a.cCusCode AND a.cCusCode = 'xxx';

 

转载于:https://my.oschina.net/u/3328774/blog/1541628