From Raymond Lewallen …
What is an HTTP Endpoint in Sql Server? Well, it is a way to create a usable interface
using HTTP or TCP for SOAP, T-Sql, Service Brokering and a few other things. I’m just
going to tell you, quick and simple, about creating a web service to return data,
although you can return scalar values, messages and errors too.; The results returned
are serialized into Xml.