A HTTP Endpoint is a Sql Server object which is use by Sql Server to communicate over the network. It includes the web method(s) which are typically the Stored Procedures (T-Sql or CLR) executed within the database and are queried by the web services.

Web services allow various applications to communicate with each other. They are based on certain standards

• Xml -> It represents the data across various platforms.
• SOAP (Simple Object Access Protocol) -> SOAP is a simple XML-based protocol to let    
  applications exchange information over HTTP.
• WSDL (Web Service Description Language) -> WSDL is an XML-based language for describing Web services and how to access them.

   

Advantage of Endpoints

a.    The advantage of a user-defined endpoint is that traffic must be authorised before it even reaches SQL Server.

b.    A SQL Server endpoint is a useful point where one can enhance the security of a SQL Server.

Creating Endpoint in SQL

CREATE ENDPOINT [MyFirstUserConnection]
STATE = STARTED
AS TCP
   (LISTENER_PORT = 1680, LISTENER_IP =ALL)
FOR TSQL () ;
GO

Looking At Endpoint

SELECT*FROMsys.endpoints