来自SQL Server的Soap Web服务调用

时间:2022-11-18 09:51:56

I'm not entirely sure if this is possible, but does anyone know how, or if you can make calls to a SOAP web service from SQL Server? Seems like it might be good performance-wise in the area of data sync applications. I feel like this might be a long shot though.

我不完全确定这是否可行,但有谁知道如何,或者你是否可以从SQL Server调用SOAP Web服务?似乎在数据同步应用程序领域可能性能良好。我觉得这可能是一个很长的镜头。

Thanks.

3 个解决方案

#1


1  

You may want to refer to this * question: SQL Server - Using CLR integration to consume a Web Service

您可能想要参考此*问题:SQL Server - 使用CLR集成来使用Web服务

#2


1  

Creating a CLR based call is pretty tedious and not really recommended. why do you want to do this? maybe we can provide another option.

创建基于CLR的呼叫非常繁琐,并不是真的值得推荐。你为什么要这样做?也许我们可以提供另一种选择。

#3


0  

If you're using SQL Server 2005 or higher, you can call a Web service by creating a CLR Procedure that does the task.

如果您使用的是SQL Server 2005或更高版本,则可以通过创建执行该任务的CLR过程来调用Web服务。

#1


1  

You may want to refer to this * question: SQL Server - Using CLR integration to consume a Web Service

您可能想要参考此*问题:SQL Server - 使用CLR集成来使用Web服务

#2


1  

Creating a CLR based call is pretty tedious and not really recommended. why do you want to do this? maybe we can provide another option.

创建基于CLR的呼叫非常繁琐,并不是真的值得推荐。你为什么要这样做?也许我们可以提供另一种选择。

#3


0  

If you're using SQL Server 2005 or higher, you can call a Web service by creating a CLR Procedure that does the task.

如果您使用的是SQL Server 2005或更高版本,则可以通过创建执行该任务的CLR过程来调用Web服务。