Sqlserver 计算两坐标距离函数

mark

1if exists (select * from dbo.sysobjects where id = object_id(N'UF_ETL_GetDistance') and xtype in (N'FN', N'IF', N'TF'))
2    drop function UF_ETL_GetDistance
3GO
4
5CREATE FUNCTION UF_ETL_GetDistance
6( 
7   @sLng    DECIMAL(12,6),
8   @sLat    DECIMAL(12,6),
9   @eLng    DECIMAL(12,6),
10   @eLat    DECIMAL(12,6)
11)
12RETURNS DECIMAL(12,4)
13AS
14BEGIN
15   DECLARE @result DECIMAL(12,4)
16   SELECT @result = 6378137.0*ACOS(SIN(@sLat/180*PI())*SIN(@eLat/180*PI())+COS(@sLat/180*PI())*COS(@eLat/180*PI())*COS((@sLng-@eLng)/180*PI()))
17   RETURN @result/1000
18END
19go