[MSSQL2008] Spatial Data in SQL Server 2008-Calculates distance between two points based on latitude and longitude

DECLARE @BJ GEOGRAPHY
DECLARE @XT GEOGRAPHY

/*
GET Latitude/longitude from Here:http://www.travelmath.com/cities/beijing,+china
The distance unit in SRID 4326 is the meter
*/
SELECT @BJ = Geography::P oint (' 39.92889 ', ' 116.38833 ', 4326)
SELECT @XT = Geography::P oint (' 37.0630556 ', ' 114.4941667 ', 4326)

SELECT
@BJ as Beijing,
@XT as Xingtai,
' The distance is ' +
CAST (@BJ. Stdistance (@XT)/1000 as VARCHAR (MAX) + ' km ' as Distance

[MSSQL2008] Spatial Data in SQL Server 2008-Calculates distance between two points based on latitude and longitude