MS SQL Server XML Integration Interview Question:

How to call stored procedure using HTTP SOAP?

Submitted by: Administrator

Stored procedures can be called using HTTP SOAP by creating endpoints. A SOAP endpoint is identified by a URL. Each endpoint supports a protocol, either HTTP OR TCP.

Syntax for Endpoint:

CREATE ENDPOINT name_of_end_point
STATE = STARTED
AS HTTP
(
PATH = specifies path of the service end point.
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = name of the host computer
)
FOR SOAP
(
WEBMETHOD - name of the web method to be used.
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = name of the database
NAMESPACE = specifies a name space for end point.
)
Submitted by: Administrator