技术教程 编程教程 sql server 根据经纬度计算两点间距离 正文

sql server 根据经纬度计算两点间距离

2023-02-22,,

DECLARE @BJ GEOGRAPHY

DECLARE @XT GEOGRAPHY


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

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

ELECT

    @BJ AS Beijing,

    @XT AS Xingtai,

    'The distance is ' +

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

或者简写：

SELECT

    top 1 CAST(geography::Point('39.92889', '116.38833', 4326).STDistance(geography::Point

    ('37.0630556', '114.4941667', 4326))/1000 AS FLOAT)

FROM

    表名

sql server 根据经纬度计算两点间距离的相关教程结束。

《sql server 根据经纬度计算两点间距离.doc》

下载本文的Word格式文档，以方便收藏与打印。

Copyright 2023. 昆居客 - IT编程,互联网信息技术文档大全!