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::Point('39.92889', '116.38833', 4326)
SELECT @XT = geography::Point('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
![[Java/LeetCode]算法练习：二进制间距(868/simple)](https://www.kunjuke.com/file/css/thumb/4.jpg/280-180.jpg)
