declare @ServiceUrl varchar(200)
set @ServiceUrl=‘http://localhost:180/xxx.asmx/Sync?Comd=’+@Comd+’&input=’+@input+’’
–Webservice 地址,方法名称,入参。
Declare @Object as Int
Declare @ResponseText as nvarchar(4000)
EXEC sp_OACreate ‘MSXML2.XMLHTTP’, @Object OUT;
Exec sp_OAMethod @Object, ‘open’, NULL, ‘get’,@ServiceUrl,‘false’ -
EXEC sys.sp_OAMethod @object,‘setRequestHeader’,NULL,‘Content-Type’,‘application/x-www-form-urlencoded;charset=UTF-8’
Exec sp_OAMethod @Object, ‘send’
EXEC sp_OAMethod @Object, ‘responseText’, @ResponseText OUTPUT
Exec sp_OADestroy @Object
RETURN @ResponseText
sql server调用webservice脚本
最新推荐文章于 2022-11-25 09:41:19 发布