SqlGeography.STPointN Method (Int32)

  • Article

 

Applies To: SQL Server 2016 Preview

Returns the specified point in a SqlGeography instance.

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

Syntax

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)]
public SqlGeography STPointN(
    int n
)

public:
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)]
SqlGeography^ STPointN(
    int n
)

[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)>]
member STPointN : 
        n:int -> SqlGeography

<SqlMethodAttribute(IsDeterministic := True, IsPrecise := True)>
Public Function STPointN (
    n As Integer
) As SqlGeography

Parameters

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography

A SqlGeography representing the specified point in the calling instance.

Remarks

If a SqlGeography instance is user-created, the STPointN method returns the point specified by expression by ordering the points in the order in which they were originally input.

If a SqlGeography instance is constructed by the system, STPointN returns the point specified by expression by ordering all the points in the same order they would be output: first by geography instance, then by ring within the instance (if appropriate), and then by point within the ring. This order is deterministic.

If this method is called with a value less than 1, it throws an ArgumentOutOfRangeException.

If this method is called with a value greater than the number of points in the instance, it returns null.

See Also

SqlGeography Class
Microsoft.SqlServer.Types Namespace

Return to top