sql servre 从一个数据库到另一个数据库

use Test
go

/启动Ad Hoc Distributed Queries/
exec sp_configure ‘show advanced options’,1
reconfigure
exec sp_configure ‘Ad Hoc Distributed Queries’,1
reconfigure

insert into Test.dbo.Test
select [Name]
,[Lat]
,[Lng]
,[Address]
,[Province]
,[City]
,[Area]
,[Tag]
,[Type]
,[Detail_Url]
,[Telephone]
,[Remark]
,[CreateDate]
,[Creator]
,[UpdateDate]
,[AlterUser]
,[DelFlag] from opendatasource(‘SQLOLEDB’,‘data source=.;USER ID=sa;PASSWORD=pws’).Test2.dbo.Test

/关闭Ad Hoc Distributed Queries/
exec sp_configure ‘Ad Hoc Distributed Queries’,0
reconfigure
exec sp_configure ‘show advanced options’,0
reconfigure