SQL SERVER 跨服务器更新操作

Question

SQL SERVER 跨服务器更新操作

Answer 1

用别名update aset a.unitname=data_upload.unitnamefrom servera.flgl_db_210500.dbo.data_upload_1 AS a,Data_Uploadwhere Data_Upload.industry_type= a.industry_type