sqlserver跨库查询简析

来源：未知责任编辑：责任编辑发表时间:2013-12-06 08:45　点击:次

将ScciDB数据库中的表数据，插入到同样表结构的另外一个数据库当中

Java代码

exec sp_configure "show advanced options",1

reconfigure

exec sp_configure "Ad Hoc Distributed Queries",1

reconfigure

insert into tb_cityCode SELECT *

from OPENROWSET('MSDASQL',

'DRIVER={SQL Server};SERVER=192.168.1.6\sqlexpress;UID=sa;PWD=123456',

ScciDB.dbo.[tb_cityCode])

www.2cto.com

insert into tb_warehouse SELECT *

from OPENROWSET('MSDASQL',

'DRIVER={SQL Server};SERVER=192.168.1.6\sqlexpress;UID=sa;PWD=123456',

ScciDB.dbo.[tb_warehouse])

exec sp_configure "Ad Hoc Distributed Queries",0

reconfigure

exec sp_configure "show advanced options",0

reconfigure

作者 libixionglbx