使用 OPENDATASOURCE 将本机的MSSQL数据插入到远程MSSQL库的表中
insert into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.100;User ID=sa;Password=sa;database=pubs'
).pubs.dbo.jobs(job_desc) select Username from Users
mssql2005 or 2008 打开 OPENDATASOURCE:
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
