Sql server

Generate Http post Request From sql server

Generate Http post Request From sql server CREATE procedure HTTP_POST(  @sUrl varchar(200),  @response varchar(8000) out) As Declare @obj int ,@ hr int ,@status int , @msg varchar(255) exec @hr = sp_OACreate ‘MSXML2.ServerXMLHttp’, @obj OUT — exec @hr = sp_OACreate ‘MSXML2.ServerXMLHttp’, @obj OUT if @hr <> 0 begin Raiserror(‘sp_OACreate MSXML2.ServerXMLHttp.3.0 failed’, 16,1) return end exec @hrContinue Reading “Generate Http post Request From sql server”