STGeometryN (geometry Data Type)
data-types #tsql#data-types
Syntax
Return Type
geometry
Arguments
n
An int expression between 1 and the number of geometries in the geometry collection.
Remarks
Returns the specified geometry from a geometry collection.
Examples
DECLARE @g geometry = geometry::STGeomFromText('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(0 0, 2 2))', 0);
SELECT @g.STGeometryN(1).ToString();