So spatial shapes can be stored in a database and calculations can be carried out on them in SQL queries. The answer is just over 402793 metres which when divided by 1609.344 gives 250 miles which is correct given that the first point is in London and the second one is in Paris. The first of these STDistance() calculates the distance between two points or shapes, in metres when using the default coordinate system, as shown in the example below: DECLARE geography SELECT = Location FROM Site WHERE ID = 1 There are many such methods including: STDistance(), STIntersection(), STUnion() and STDifference(). The spatial data types also have built in methods allowing spatial computations to be carried out as part of an SQL query. Some example inserts into a table that has a Location column of type geography are: INSERT INTO Site (ID, Location) Geography: Stores spatial data on a sphere, or to be more exact the earthДata can be inserted into a geography column in a table using references to spatial data objects such as POINT, LINESTRING, POLYGON etc.Geometry: Stores spatial data on a flat surface.Spatial data types were first introduced in SQL Server 2008 and allow points, lines and shapes to be stored inside a column inside a database table.

Adventureworks2012 person type