假设您的GeoLoc列在SQL Server中为“地理位置”数据类型,则您应该可以使用以下内容:
select t1.*, t2.*, t1.GeoLoc.STDistance(t2.GeoLoc) as DistanceApartfrom table1 t1join table2 t2on (t1.GeoLoc.STDistance(t2.GeoLoc) <= @distanceX)
“ DistanceApart”和“ distanceX”值以米为单位

假设您的GeoLoc列在SQL Server中为“地理位置”数据类型,则您应该可以使用以下内容:
select t1.*, t2.*, t1.GeoLoc.STDistance(t2.GeoLoc) as DistanceApartfrom table1 t1join table2 t2on (t1.GeoLoc.STDistance(t2.GeoLoc) <= @distanceX)
“ DistanceApart”和“ distanceX”值以米为单位