获取经纬度之间的距离的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)