摘要:
--获取经纬度之间的距离(单位:米)CREATE function dbo.GetDistance(@Lon1 float,@Lat1 float,@Lon2 float,@Lat2 float) returns floatasbegindeclare @ret float;declare @r float;declare @A float;declare @B float;declare @RA float;declare @RB float;declare @RL1 float;declare @RL2 float;select @r = 6371138, @A = abs(@Lat1 - 阅读全文