共用方式為


SqlGeography.STDistance 方法

Returns the shortest distance between a point in a SqlGeography instance and a point in another SqlGeography instance.

命名空間:  Microsoft.SqlServer.Types
組件:  Microsoft.SqlServer.Types (在 Microsoft.SqlServer.Types.dll 中)

語法

'宣告
<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)> _
Public Function STDistance ( _
    other As SqlGeography _
) As SqlDouble
'用途
Dim instance As SqlGeography 
Dim other As SqlGeography 
Dim returnValue As SqlDouble 

returnValue = instance.STDistance(other)
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public SqlDouble STDistance(
    SqlGeography other
)
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public:
SqlDouble STDistance(
    SqlGeography^ other
)
[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)>]
member STDistance : 
        other:SqlGeography -> SqlDouble
public function STDistance(
    other : SqlGeography
) : SqlDouble

參數

  • other
    型別:Microsoft.SqlServer.Types.SqlGeography
    Is another geography instance from which to measure the distance between the instance on which STDistance is invoked. If an empty set is specified, STDistance will return null.

傳回值

型別:System.Data.SqlTypes.SqlDouble
Returns null if the spatial reference IDs (SRIDs) of the SqlGeography instances do not match.If this method is used to determine distance between antipodal points, or consecutive points on opposite sides of the globe, as in the distance between POINT (0 0) and POINT (180 0), this method will return null.

請參閱

參考

SqlGeography 類別

Microsoft.SqlServer.Types 命名空間