SQL SERVER 跨服务器更新操作

Question

SQL SERVER 跨服务器更新操作

Answer 1

用别名

update a
set a.unitname=data_upload.unitname
from servera.flgl_db_210500.dbo.data_upload_1 AS a,Data_Upload
where Data_Upload.industry_type= a.industry_type