|
|
Concepts and capabilities of SOAP
|
Concepts and capabilities of
SOAP - March 16, 2009 at 16:45 PM by Amit Satpute
Concepts and capabilities of SOAP
-
With the Native XML Web Services in SQL Server 2005 / 2008, SOAP messaging
requests can be sent to an instance of SQL Server over HTTP to run the
following:
-Transact-SQL batch statements, with or without parameters.
-Stored procedures, extended stored procedures, and scalar-valued user-defined
functions.
-
Tabular Data Stream (TDS) protocol used to be used to connect to SQL server
prior to SQL Server 2005.
-
With SOAP/HTTP access provides an open and documented protocol that may be used
as an option to connect to SQL Server.
-
Providing SOAP/HTTP access enables a broader range of clients to access SQL
Server.
-
It facilitates interoperability with .NET, SOAP Toolkit, Perl, and more on a
variety of platforms.
-
SOAP/HTTP access mechanism inherently promotes interoperability and access to
SQL Server in a heterogeneous environment as it is based on well-known
technologies such as XML and HTTP.
|
|
|
|
|
