首先要保证服务器开启了 Ad Hoc Distributed Queries
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
insert into 表名 select *
from OPENROWSET('SQLOLEDB',
'SERVER=192.168.1.101;uid=数据库用户名;pwd=数据库密码;Database=数据库名称,'select * from 表名') as a