摘要:
--获取经纬度之间的距离(单位:米)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
阅读(796)
推荐(0)
编辑