通过sql函数调用接口

ALTER procedure [dbo].[execWechat]
--@parameter varchar(20)
as
begin
    declare @obj int
    declare @url varchar(200)
    declare @response varchar(5000)
    set  @url='www.baidu.com'--+@parameter+''
    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 case when @response = '' then 'Success' else 'fail' end as result
    --select @response out
    insert into ExecWechatStatus 
    
    select case when @response like '%true%' then 'Success' else 'fail' end as result,GETDATE()
    exec sp_OADestroy @obj
end