DECLARE @g geography;
SET @g = geography::STPointFromText(‘POINT(113.216273 23.236333)‘, 4326);
SELECT @g.ToString();
DECLARE @gg geography;
SET @gg = geography::STPointFromText(‘POINT(115.567368 37.341209)‘, 4326);
SELECT @gg.ToString();

SELECT @g.STDistance(@gg)

sql 计算两经纬度间的距离,布布扣,bubuko.com

sql 计算两经纬度间的距离