6,129
社区成员
发帖
与我相关
我的任务
分享
--DECLARE @g geography;
--DECLARE @h geography;
--SET @g = geography::STGeomFromText('POINT(113.91 22.542433)', 4326);
--SET @h = geography::STGeomFromText('POINT(113.65 22.542439)', 4326);
--SELECT @g.STDistance(@h);
DECLARE @g geography;
DECLARE @h geography;
Set @GPSLng=Convert(decimal(12,6), @GPSLng);
Set @GPSLat=Convert(decimal(12,6),@GPSLat);
Set @Lng=Convert(decimal(12,6), @Lng);
Set @Lat=Convert(decimal(12,6),@Lat);
--SET @g = geography::STGeomFromText('POINT(113.91 22.542433)', 4326);
--SET @h = geography::STGeomFromText('POINT(113.65 22.542439)', 4326);
SET @g =geography::STGeomFromText('POINT('+@GPSLng+ @GPSLat+')', 4326);
SET @h =geography::STGeomFromText('POINT('+@Lng+ @Lat+')', 4326);
return Convert(decimal(12,6), @g.STDistance(@h));
SET @g =geography::STGeomFromText('POINT('+RTRIM(@GPSLng)+' '+ RTRIM(@GPSLat)+')', 4326);
SET @h =geography::STGeomFromText('POINT('+RTRIM(@Lng)+' '+ RTRIM(@Lat)+')', 4326);