SQL2005 導(dǎo)入其它服務(wù)器數(shù)據(jù)

首先設(shè)置SQL2005服務(wù)組件

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

再通過SQL語句來查詢導(dǎo)入數(shù)據(jù)

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

SQL2005 導(dǎo)入其它服務(wù)器數(shù)據(jù)

首先設(shè)置SQL2005服務(wù)組件

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

再通過SQL語句來查詢導(dǎo)入數(shù)據(jù)

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