在网上 发现了如下以下一段代码,但是post的数据改传到哪?
alter procedure [dbo].[proc_CallWebService]
as
begin
declare @obj int
declare @url varchar(200)
declare @response varchar(5000)
set @url='http://1******4/WEB.RequestSenderService/Service/AuthRequest'
exec sp_OACreate 'MSXML2.ServerXMLHttp',@obj out
exec sp_OAMethod @obj,'Open',null,'post',@url,false
exec sp_OAMethod @obj,'send'
exec sp_OAGetProperty @obj,'responseText',@response out
select @response [response]
exec sp_OADestroy @obj
END
- 8 回答
- 0 关注
- 1114 浏览
添加回答
举报
0/150
提交
取消