Microsoft SQL Server - Create Web Service

first line is to Create End Point for web service.
State can be of three types: STARTED Means Listening and Responding, DISABLED Means Neither Listening nor Responding And STOPPED Means Listening But Not Responding

specify the Transport Protocol to used
{HTTP | TCP}

Authentication mode is of three types INTEGRATED Is More Secure, While Basic is Least Secure and Digest is not Secure Authentication type

CLEAR (HTTP - port 80 by default) SSL (HTTPS - port 443 by default)
PORTS= {CLEAR | SSL}

BATCHES= {ENABLED | DISABLED}
if ENABLED, multiple SOAP request/response message pairs can be identified as part of a single SOAP session.

CREATE ENDPOINT XMLHTTPEndPoint
STATE= {STARTED | STOPPED | DISABLED}
AS
{HTTP | TCP}
(
PATH = (e.g.: '/Webservices',)
AUTHENTICATION= (BASIC | DIGEST | INTEGRATED),
PORTS= {CLEAR | SSL},
SITE=
)
FOR {SOAP | TSQL}
(
WEBMETHOD
(NAME=),
BATCHES= {ENABLED | DISABLED},
WSDL= {NONE | DEFAULT | 'sp_name'},DATABASE = <Database Name>>
NAMESPACE= http://<Server Name>/( Name where you want to create Web service)
)

WSDL Specify how the Document Generation Will Occur. If none no Response is generated or returned for query.