Update,Delete配合INNER JOIN使用

工作要求：將本地的表更新到DataServer資料庫的對應表中
      Update DServer set  DServer.[emp_id]=History.[emp_id]
      ,DServer.[seq_no]=History.[seq_no]
      ,DServer.[contract_years]=History.[contract_years]    
      ,DServer.[remark]=History.[remark]
      ,DServer.[modify_emp]=History.[modify_emp]
      ,DServer.[modify_date]=History.[modify_date]
      From DATASERVER.HRMS.dbo.EmployeeJobHistory As DServer
      Inner join EmployeeJobHistory As History on History.history_id=DServer.history_id
      where @Max_modify_date_EmployeeJobHistory>@Max_modify_date_EmployeeJobHistory_server

文法：update 更新表 set 欄位=? from 更新表 inner join 連結資料表 on...

DELETE文法類似
delete 刪除表 from 刪除表 inner join 連結資料表 on...