I’ve covered a wide variety of SQL Server-based XML tools so far, including the xml data type, XML Schema, XQuery, and Extensible Stylesheet Language Transformations (XSLT). In addition to all this XML functionality, SQL Server also provides support for XML-based Simple Object Access Protocol (SOAP) endpoints over Hypertext Transfer Protocol (HTTP). SOAP provides the ability to serialize objects using XML, and HTTP provides the communication protocol to send and receive SOAP-based objects. In a nutshell, this means that you can use a SQL Server instance directly as a web service server. SQL Server provides built-in support for exposing stored procedures and user-defined functions as web service methods using SOAP. Using HTTP SOAP endpoints, you can access these exposed stored procedures and functions remotely with minimal effort.
KeywordsClient Application Simple Object Access Protocol Transfer Control Protocol Internet Information Service Official Word
Unable to display preview. Download preview PDF.