SQL2005导入其它服务器数据
首先设置SQL2005服务
组件
www.2cto.com
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
再通过SQL语句来查询导入数据 www.2cto.com
insert into sa_tree select * from OPENROWSET('SQLOLEDB',
'SERVER=172.27.27.126;uid=sa;pwd=jibojibo;Database=snsDB','select * from sa_tree') as a