sql server post方法

USE [myehr]
GO

/****** Object: StoredProcedure [dbo].[httpPost] Script Date: 10/17/2018 17:14:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[httpPost]
@urls VARCHAR(MAX) ,
@obj INT ,
@RETVAL INT OUTPUT

AS
BEGIN

BEGIN
DECLARE @url VARCHAR(200)
DECLARE @response VARCHAR(5000)
SET @url=@urls
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

END

GO

 

转载于:https://www.cnblogs.com/xy888/p/9805399.html