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