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...