先取消自增字段，手动添加自增字段id。一个实例只能打开一个IDENTIFY_INSERT。
SET IDENTITY_INSERT TABLEA ON insert into TABLEA (id,name) SELECT id,name FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=IP;User ID=sa;Password=123').DATABASENAME.dbo.TABLEBSET IDENTITY_INSERT TABLEA OFF