exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE
INSERT INTO userinfo
Select a.*
FROM OPENROWSET('SQLOLEDB','172.18.9.157';'sa';'sa',
'Select * FROM [test].dbo.userinfo') AS a
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。