Sql根据经纬度算出距离

fteair · 发表于 2020-2-28 17:56:10

SELECT ISNULL((2 * 6378.137 * ASIN(SQRT(POWER(SIN((117.223372- ISNULL(Latitude,0) )*PI()/360),2)+COS(117.223372*PI()/180)*COS(117.223372*PI()/180)*POWER(SIN((117.223372- ISNULL(Longitude,0) )*PI()/360),2)))),0) AS Distance FROM RequirementOrder r where r.RequirementOrderID not in (SELECT O.RequirementOrderID from OrdersDetail O)

fteair · 发表于 2020-2-28 17:45:17

fteair · 发表于 2020-2-28 17:45:45

张兴康 · 发表于 2020-2-28 14:00:36

fteair · 发表于 2020-2-28 17:42:15

fteair · 发表于 2020-2-28 17:43:20

		自动登录	找回密码
密码			立即注册

[分享] Sql根据经纬度算出距离