Call a SOAP WebService from a Stored Procedure (SQL Server 2012 - Can't use CLR!)

Question

I'm looking for an Stored Procedure to make a SOAP request. Pass in a SOAP envelope. I can not use a CLR. I have seen countless SP to but all return a 202 and nothing is processed.

https://www.codeproject.com/articles/428200/how-to-invoke-a-web-service-from-a-stored-procedure https://www.c-sharpcorner.com/blogs/how-to-call-web-service-using-sql

Where and how can I make a SOAP request from SQL Server 2012+ in T-SQL ? Any examples would help.

thanks in advance

Answer 1

等待大神答复