不同机器中数据库表间数据互导
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
insert into t_visitorData(keyword)
select k_name from
openrowset('SQLOLEDB','192.168.5.3';'Search';'Sea123',Win_Basis.dbo.B_T_KeyWords)
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
insert into t_visitorData(keyword)
select k_name from
openrowset('SQLOLEDB','192.168.5.3';'Search';'Sea123',Win_Basis.dbo.B_T_KeyWords)