exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
delete from A库.dbo.a表
insert into A库.dbo.a表
select a.* FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=.;UID=sa;PWD=Foxconn99',
B库.dbo.b表) AS a
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure