跨服务器导入数据sql

INSERT INTO [dbname].[dbo].[tableName]
([ID]
)
select ID from openrowset ( 'SQLOLEDB' , '127.0.0.1' ; 'sa' ; 'sa' ,[dbname].[dbo].[tableName])
where status=0