sql server geometry 距离_sql server怎么用_sqlserver 选择列说明

[MSSQL2008]Spatial Data in SQL Server 2008 - 根据经纬度计算两点间距离

DECLARE @ GEOGRAPHY

DECLARE @XT GEOGRAPHY

/*

GET Latitude/Longitude FROM here:,+China

the distance unit in SRID 4326 is the meter

*/

SELECT @ = geography::Point('39.92889', '116.38833', 4326)

SELECT @XT = geography::Point('37.0630556', '114.4941667', 4326)

SELECT

@ AS Beijing,

@XT AS Xingtai,

'The distance is ' +

CAST(@.STDistance(@XT)/1000 AS VARCHAR(MAX)) + ' km' AS Distance

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-48401-1.html