先取消自增字段,手动添加自增字段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.TABLEB
SET IDENTITY_INSERT TABLEA OFF