- declare @ServiceUrl as varchar(1000)
- declare @UrlAddress varchar(500)
--webService 地址: 以 http 开头, 结尾带斜杠, 例如'http://webservice.webxml.com.cn/WebServices/MobileCodeWS.asmx/'
- set @UrlAddress = 'http://139.224.134.5/SGAppService/SGService.asmx/'
- declare @FunName varchar(50)
--WebService 中调用的方法名: 例如'getMobileCodeInfo'
set @FunName = 'PushContractApproval'
-- 以下参数对应 WebService 中 4 个参数的 [参数名]
- declare@P1 varchar(100),
- @P2 varchar(100) set@P1 = 'data'set@P2 = 'userid'declare@P1_Value varchar(max),
- @P2_Value varchar(800) set@P1_Value = '{"ServerLicenseID":"61DD8BE1-9458-41FB-AA56-DA11634E11CD"}'set@P2_Value = ''set@ServiceUrl = @UrlAddress + @FunName + '?' + @P1 + '=' + @P1_Value Declare@Object as Int Declare@ResponseText as Varchar(8000) Exec sp_OACreate 'MSXML2.XMLHTTP',
- @Object OUT;
- Exec sp_OAMethod@Object,
- 'open',
- NULL,
- 'get',
- @ServiceUrl,
- 'false'Exec sp_OAMethod@Object,
- 'send'Exec sp_OAMethod@Object,
- 'responseText',
- @ResponseText OUTPUT Select@ResponseText Exec sp_OADestroy@Object
来源: http://www.bubuko.com/infodetail-2774646.html