跨服务器访问数据库

最新推荐文章于 2021-08-09 22:08:24 发布

PatyTime

最新推荐文章于 2021-08-09 22:08:24 发布

阅读量544

点赞数

分类专栏： MSSqlserver 2008R2 数据库文章标签：数据库

本文链接：https://blog.csdn.net/u012861746/article/details/46363149

版权

MSSqlserver 2008R2 数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

--插入语句

insert into WxOrderInfo( AppId, Bank_Type, Cash_Fee, Fee_Type, Is_Subscribe, Mch_id, Nonce_Str, OpenId, Out_Trade_No, Result_Code, Return_Code, [Sign], Time_End, Total_Fee, Trade_Type, Transaction_Id, States)

SELECT AppId, Bank_Type, Cash_Fee, Fee_Type, Is_Subscribe, Mch_id, Nonce_Str, OpenId, Out_Trade_No, Result_Code, Return_Code, [Sign], Time_End, Total_Fee, Trade_Type, Transaction_Id, States
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=hjxu;User ID=sa;Password=global'
).webticket.dbo.WxOrderInfo

--启用Ad Hoc Distributed Queries：
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

--关闭Ad Hoc Distributed Queries：
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure