STNumGeometries (geometry Data Type)
data-types #tsql#data-types
Syntax
Return Type
int
Remarks
Returns the number of geometries in a geometry collection.
Examples
DECLARE @g geometry = geometry::STGeomFromText('MULTIPOINT((1 1), (2 2))', 0);
SELECT @g.STNumGeometries() AS NumberOfGeometries;