Basic stored procedures:
/****** object:storedprocedure [dbo]. [Spcallboservice] Script date:11/19/2015 16:45:14 ******/
SET ANSI_NULLS on
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo]. [Spcallboservice]
(
@Url NVARCHAR (MAX) = ' http://192.168.0.151:8085/BillService.asmx/',
@MethodName VARCHAR = ' HelloWorld ',
@Parameters NVARCHAR (MAX) = ",
@result VARCHAR (MAX) out
)
As
DECLARE @obj INT
DECLARE @ValorDeRegreso INT
DECLARE @response VARCHAR (8000)
SET @Url = @Url + @MethodName
IF LEN (@Parameters) > 0
BEGIN
SET @Url + = '? ' + @Parameters
END
PRINT @Url
EXEC sp_OACreate ' msxml2.xmlhttp ', @obj out
EXEC sys.sp_oamethod @obj, ' Open ', NULL, ' Get ', @Url, False
EXEC sp_OAMethod @obj, ' send '
EXEC sys.sp_oagetproperty @obj, ' responsetext ', @response out
SET @result = @response
EXEC Sys.sp_oadestroy @obj
How to use:
/****** object:storedprocedure [dbo]. [Sp_callsynfailuresendmcodetomticket] Script date:11/19/2015 16:48:30 ******/
SET ANSI_NULLS on
GO
SET QUOTED_IDENTIFIER ON
GO
--Author: Zeng Tim Lee
--Create date:2015-11-18
--Description: Timed sync big turntable m coupon system failed m coupon
-- =============================================
CREATE PROCEDURE [dbo]. [Sp_callsynfailuresendmcodetomticket]
As
BEGIN
DECLARE @result NVARCHAR (1000)
EXEC dbo.spcallboservice @Url = N ' http://192.168.0.37:8080/WebService.asmx/',--nvarchar (max)
@MethodName = ' executecontrolfunction ',--varchar (50)
@Parameters = N ' paramjson=["MyjWeiXin.Controllers.Activity.Roulette.RoulettePage", "Synfailuresendmcodetomticket" ] ',--nvarchar (max)
@result = @result OUTPUT-varchar (max)
PRINT @result
END
SQL Call Web Service