sqlServer根据经纬查距离

SELECT
	* 
FROM
	(
	SELECT
		STNM,
		LGTD,
		lttd,
		ACOS(
			SIN( ( 37.382404 * 3.1415 ) / 180 ) * SIN( ( LTTD * 3.1415 ) / 180 ) + COS( ( 37.382404 * 3.1415 ) / 180 ) * COS( ( LTTD * 3.1415 ) / 180 ) * COS( ( 122.359722 * 3.1415 ) / 180 - ( LGTD * 3.1415 ) / 180 ) 
		) * 6371.004 AS dis 
	FROM
	ST_STBPRP_B 
	) B