STInteriorRingN (geometry Data Type)

Syntax

Return Type

geometry

Arguments

n

An int expression between 1 and the number of interior rings in the polygon.

Remarks

Returns the specified interior ring of a polygon geometry instance.

Examples

DECLARE @g geometry = geometry::STGeomFromText('POLYGON((0 0, 4 0, 4 4, 0 4, 0 0), (1 1, 1 2, 2 2, 2 1, 1 1))', 0);
SELECT @g.STInteriorRingN(1).ToString();