sqlserver获取其他网页数据

最新推荐文章于 2024-05-15 10:06:49 发布

糖朝

最新推荐文章于 2024-05-15 10:06:49 发布

阅读量767

点赞数 1

分类专栏：金蝶cloud

本文链接：https://blog.csdn.net/huang4998802/article/details/108732664

版权

金蝶cloud 专栏收录该内容

27 篇文章 13 订阅

订阅专栏



 sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO



declare @ServiceUrl as varchar(1000) 
set @ServiceUrl = 'http://192.168.2.8:38888/plan/update.xml'
DECLARE @data varchar(max);
set @data=''                  

Declare @Object as Int
Declare @ResponseText AS  varchar(8000)   ;      
Exec sp_OACreate 'Msxml2.ServerXMLHTTP.3.0', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'GET',@ServiceUrl,'false'
Exec sp_OAMethod @Object, 'send', NULL, @data --发送数据
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
--EXEC sp_OAGetErrorInfo @Object --异常输出
Select  @ResponseText 
Exec sp_OADestroy @Object
GO