declare
@lng1/*经度1*/ float='121.266984'
,@lat1/*纬度1*/ float='31.123981'
,@lng2/*经度2*/ float='121.411215'
,@lat2/*纬度2*/ float='31.190184'
select round(6371004*acos(sin(@lat1/180*pi())*sin(@lat2/180*pi())+cos(@lat1/180*pi())*cos(@lat2/180*pi())*cos((@lng1-@lng2)/180*pi()))/1000,2)
/*15.57(单位:公里)*/
04-16
6227