How to call stored procedure using HTTP SOAP?
Submitted by: AdministratorStored 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
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
Read Online MS SQL Server XML Integration Job Interview Questions And Answers
Top MS SQL Server XML Integration Questions
☺ | What is the OPENXML statement in SQL Server? |
☺ | What is FOR XML in SQL Server? |
☺ | What are XML indexes? |
☺ | How to call stored procedure using HTTP SOAP? |
☺ | What is XMLA? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |