1. /****** Object:  StoredProcedure [dbo].[sp_http_get]    Script Date: 05/23/2020 15:47:09 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4.  
  5. SET QUOTED_IDENTIFIER ON
  6. GO
  7.  
  8.  
  9. CREATE PROCEDURE [dbo].[sp_http_get](
  10.     @URL varchar(500),
  11.     @ResponseText varchar(8000) OUTPUT
  12. )
  13. AS
  14. BEGIN
  15.  
  16. Declare @Status as Int   
  17. Exec sp_OACreate 'Msxml2.ServerXMLHTTP.3.0', @Status OUT;
  18. Exec sp_OAMethod @Status, 'open', NULL, 'GET',@URL,'false'
  19. Exec sp_OAMethod @Status, 'send', NULL, NULL
  20. Exec sp_OAMethod @Status, 'responseText', @ResponseText OUTPUT
  21. if @Status<>0
  22.   begin
  23.     EXEC sp_OAGetErrorInfo @Status
  24.   end
  25. Exec sp_OADestroy @Status
  26. END
  27.  
  28. GO
  29.  
  30.  
  31. CREATE PROCEDURE [dbo].[sp_http_post](
  32.     @URL varchar(500),
  33.     @Data varchar(8000),
  34.     @ResponseText varchar(8000) OUTPUT
  35. )
  36. AS
  37. BEGIN
  38.  
  39. Declare @Status as Int   
  40. Exec sp_OACreate 'Msxml2.ServerXMLHTTP.3.0', @Status OUT;
  41. Exec sp_OAMethod @Status, 'open', NULL, 'POST',@URL,'false'
  42. Exec sp_OAMethod @Status, 'send', NULL, @Data
  43. Exec sp_OAMethod @Status, 'responseText', @ResponseText OUTPUT
  44. if @Status<>0
  45.   begin
  46.     EXEC sp_OAGetErrorInfo @Status
  47.   end
  48. Exec sp_OADestroy @Status
  49. END
  50.  
  51.  
  52. GO

 

版权声明：本文为icyhoo原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/icyhoo/p/12942833.html