代码 exec sp_configure &＃39;show advanced options&＃39;,1
reconfigure
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,1
reconfigure
GO
SELECT * into #tempxx FROM openrowset(&＃39;SQLOLEDB&＃39;,&＃39;服务器&＃39;;&＃39;登录用户&＃39;;&＃39;密码&＃39;,&＃39;SELECT * FROM athletic.dbo.imatposcheckOnlineHD&＃39;);
GO
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,0
reconfigure
exec sp_configure &＃39;show advanced options&＃39;,0
reconfigure
reconfigure
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,1
reconfigure
GO
SELECT * into #tempxx FROM openrowset(&＃39;SQLOLEDB&＃39;,&＃39;服务器&＃39;;&＃39;登录用户&＃39;;&＃39;密码&＃39;,&＃39;SELECT * FROM athletic.dbo.imatposcheckOnlineHD&＃39;);
GO
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,0
reconfigure
exec sp_configure &＃39;show advanced options&＃39;,0
reconfigure
![[译]技术公司十年经验的职场生涯回顾](https://img8.php1.cn/3cdc5/24912/711/b6574f3292f9dc00.png)
京公网安备 11010802041100号