How to use SQL Web Service Endpoints for TSQL
The MSDN documentation for CREATE ENDPOINT notes the following:


  Native XML Web Services (SOAP/HTTP endpoints) was removed in SQL Server 2012.


So, unless you are using an unsupported version of SQL Server prior to SQL Server 2012, you cannot create an endpoint for http or xml.

If you are considering create a T-SQL endpoint, every SQL Server already has a T-SQL endpoint built in by default and there is absolutely no need to create another one. By default, the T-SQL endpoint listens on port 1433, although that is configurable.