Export (0) Print
Expand All
Expand Minimize

SqlGeography.STLength Method

Returns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection.

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

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public SqlDouble STLength()

Return Value

Type: SqlDouble
A SqlDouble value containing the total length.

If a SqlGeography instance is closed, its length is calculated as the total length around the instance; the length of any polygon is its perimeter, and the length of a point is 0. The length of a GeometryCollection is found by calculating the sum of the lengths of all of the SqlGeography instances contained within the collection.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft