摘要: --获取经纬度之间的距离(单位:米)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 - 阅读全文
posted @ 2011-04-01 14:42 zengjun 阅读(797) 评论(0) 推荐(0) 编辑