*POWER(SIN(@RadLngDiff / 2), 2)
go
POWER(SIN(@RadLatDiff / 2), 2)+COS(@RadLatBegin)*COS(@RadLatEnd)
)
SET @RadLatBegin = @LatBegin *PI()/ 180.0
RETURNSFLOAT
SQRT(

--SET @Distance = Round(@Distance * 10000) / 10000
DECLARE @EARTH_RADIUS REAL
--距离(千米)

--LatBegin 开始经度
SET @Distance = 2 *ASIN(
SET @RadLatEnd = @LatEnd *PI()/ 180.0
END
--LngBegin 开始维度
--创建经纬度距离计算函数
)
SET @EARTH_RADIUS = 6378.137

SET @RadLngDiff = @LngBegin *PI()/ 180.0 - @LngEnd *PI()/ 180.0

SQL SERVER 根据地图经纬度计算距离的公式
BEGIN
DECLARE @Distance REAL


RETURN @Distance

复制代码 代码如下:

AS
@RadLatEnd REAL,
CREATEFUNCTION [dbo].[fnGetDistance]
SET @RadLatDiff = @RadLatBegin - @RadLatEnd
@RadLngDiff REAL
@Distance的单位为:千米
(@LatBegin REAL, @LngBegin REAL, @LatEnd REAL, @LngEnd REAL)

DECLARE @RadLatBegin REAL,
@RadLatDiff REAL,

SET @Distance = @Distance * @EARTH_RADIUS