SQL Server Call HTTP URL เรียกใช้งาน URL Website จาก Stored Procedure

CREATE PROCEDURE [dbo].[HTTPWebRequest]( @sUrl VARCHAR(500))
AS

	DECLARE		@oObject	INT;
	DECLARE		@oHr		INT;
	DECLARE		@sMsg	VARCHAR(255)


	EXEC @oHr = sp_OACreate 'MSXML2.ServerXMLHttp', @oObject OUT
	IF @oHr <> 0 BEGIN  RAISERROR('sp_OACreate MSXML2.ServerXMLHttp.3.0 failed', 16,1) RETURN END


	EXEC @oHr = sp_OAMethod @oObject, 'open', NULL, 'POST', @sUrl, False
	IF @oHr <>0 BEGIN SET @sMsg = 'sp_OAMethod Open failed' GOTO EH END


	EXEC @oHr = sp_OAMethod @oObject, 'setRequestHeader', NULL, 'Content-Type',
	'application/x-www-form-urlencoded'
	IF @oHr <>0 BEGIN SET @sMsg = 'sp_OAMethod setRequestHeader failed' GOTO EH END


	EXEC @oHr = sp_OAMethod @oObject, SEND, NULL, ''
	IF @oHr <> 0 BEGIN SET @sMsg = 'sp_OAMethod Send failed' GOTO EH END

	EXEC @oHr = sp_OADestroy @oObject
	RETURN;
EH:
	EXEC @oHr = sp_OADestroy @oObject
		RAISERROR(@sMsg, 16, 1)
	RETURN;

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO