Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

STNumInteriorRing (geometry Data Type)

Returns the number of interior rings of a Polygongeometry instance.


.STNumInteriorRing ( )

SQL Server return type: int

CLR return type: SqlInt32

This method returns null if the geometry instance is not a polygon.

The following example creates a Polygon instance and uses STNumInteriorRing() to find how many interior rings the instance has.

DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POLYGON((0 0, 3 0, 3 3, 0 3, 0 0),(2 2, 2 1, 1 1, 1 2, 2 2))', 0);
SELECT @g.STNumInteriorRing();

Community Additions

ADD
Show:
© 2015 Microsoft