需要将本地的几张表增量备份到另一个服务器中其中有一句SQL是这样的
Insert into DATASERVER.HRMS.dbo.EmployeeTranslate select * from EmployeeTranslate where DATASERVER.HRMS.dbo.EmployeeTranslate.emp_id not in (select emp_id from EmployeeTranslateHistory)
SQL SERVER对这句话报错:无法绑定由多个部分组成的标识符
需要将DATASERVER上的表取别名来CALL上面表的字段
正确的SQL是:Insert into DATASERVER.HRMS.dbo.EmployeeTranslate
select * from EmployeeTranslate orign where orign.emp_id not in
(select destHistory.emp_id from DATASERVER.HRMS.dbo.EmployeeTranslate destHistory )