04 2011 档案
获取经纬度之间的距离的SQL函数(转)
摘要:--获取经纬度之间的距离(单位:米)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 阅读(814) 评论(0) 推荐(0)