insert into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=XXXX;User ID=XXX;Password=XXX'
).数据库名.dbo.表名(...)
SELECT top 500 ...
FROM 表名
insert into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=XXXX;User ID=XXX;Password=XXX'
).数据库名.dbo.表名(...)
SELECT top 500 ...
FROM 表名