我认为您最好将其放入UDF并在查询中使用它：
SELECt v.lat, v.lng, v.name, p.lat, p.lng, p.postpre, udf_Haversine(v.lat, v.lng, p.lat, p.lng) AS distance FROM venuepostpres v, postpreLngLat p WHERe p.outpre = 'CB6' ORDER BY distancecreate function dbo.udf_Haversine(@lat1 float, @long1 float, @lat2 float, @long2 float) returns float begin declare @dlon float, @dlat float, @rlat1 float, @rlat2 float, @rlong1 float, @rlong2 float, @a float, @c float, @R float, @d float, @DtoR float select @DtoR = 0.017453293 select @R = 3937 --3976 select @rlat1 = @lat1 * @DtoR, @rlong1 = @long1 * @DtoR, @rlat2 = @lat2 * @DtoR, @rlong2 = @long2 * @DtoR select @dlon = @rlong1 - @rlong2, @dlat = @rlat1 - @rlat2 select @a = power(sin(@dlat/2), 2) + cos(@rlat1) * cos(@rlat2) * power(sin(@dlon/2), 2) select @c = 2 * atn2(sqrt(@a), sqrt(1-@a)) select @d = @R * @c return @d end
