How to get type of geometry in SQL Server?

Question

I'm working with the geometry types in SQL Server and I'm wondering if there's any function to tell what kind of geometry something is (point, multipoint, polygon, etc.)?

Answer 1

Looks like you want STGeometryType:

The OGC type names that can be returned by STGeometryType() are Point, LineString, Polygon, GeometryCollection, MultiPoint, MultiLineString, and MultiPolygon.