基本存储过程:
- /****** 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(50) = 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
来源: http://www.bubuko.com/infodetail-2535455.html