Export (0) Print
Expand All
Expand Minimize

SqlGeography.STGeometryN Method

Returns a specified geography element in a GeometryCollection or one of its subtypes.

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

<SqlMethodAttribute(IsDeterministic := True, IsPrecise := True)> _
Public Function STGeometryN ( _
	n As Integer _
) As SqlGeography
Dim instance As SqlGeography 
Dim n As Integer 
Dim returnValue As SqlGeography 

returnValue = instance.STGeometryN(n)


Type: Int32
An int expression between 1 and the number of SqlGeography instances in the GeometryCollection.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography
A SqlGeography element from the specified instance in the GeometryCollection.

When this method is used on a subtype of a GeometryCollection, such as MultiPoint or MultiLineString, this method returns the SqlGeography instance if called with N=1.

This method returns null if the parameter is larger than the result of STNumGeometries and will throw an ArgumentOutOfRangeException if the expression parameter is less than 1.

Community Additions

© 2014 Microsoft