Partilhar via

  • Artigo

Método STDistance

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

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (em Microsoft.SqlServer.Types.dll)

Sintaxe

'Declaração
<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)> _
Public Function STDistance ( _
    other As SqlGeography _
) As SqlDouble
'Uso
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

Parâmetros

  • other
    Tipo: 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.

Valor de retorno

Tipo: 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.