备注:两库两表联合修改

update ar_tradevv.dbo.mainProductType  set  ar_tradevv.dbo.mainProductType.typename=testdb.dbo.a.ar  from  ar_tradevv.dbo.mainProductType,testdb.dbo.a  where  ar_tradevv.dbo.mainProductType.tid= testdb.dbo.a.id

原文地址:https://www.cnblogs.com/zmxmiss/p/1786622.html