从SQL调用Web服务

问题描述:

我有一个用C#编写的Web服务.我需要知道如何通过SQL过程调用此Web服务.

I have a webservice wrritten in C# . I need to know how can i call this webservice through a SQL procedure.

请参阅此博客文章
http://blog.hoegaerden.be/2008 /11/11/calling-a-web-service-from-sql-server-2005/ [
Have a look at this blog post
http://blog.hoegaerden.be/2008/11/11/calling-a-web-service-from-sql-server-2005/[^]


您可以创建用户定义的函数在SQL Server中使用,并将其用于Web服务调用.

若要创建UDF,请参见例如: http://msdn.microsoft.com/en-us/library /ms191320.aspx [ ^ ]
You can create a user defined function inside the SQL Server and use that for the web service call.

To create an UDF, see for example: http://msdn.microsoft.com/en-us/library/ms191320.aspx[^]