SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Data Types (Transact-SQL)

Spatial Types

geometry (Transact-SQL)

geometry Data Type Method Reference

OGC Methods on Geometry Instances

STArea (geometry Data Type)

STAsBinary (geometry Data Type)

STAsText (geometry Data Type)

STBoundary (geometry Data Type)

STBuffer (geometry Data Type)

STCentroid (geometry Data Type)

STContains (geometry Data Type)

STConvexHull (geometry Data Type)

STCrosses (geometry Data Type)

STCurveN (geometry Data Type)

STCurveToLine (geometry Data Type)

STDifference (geometry Data Type)

STDimension (geometry Data Type)

STDisjoint (geometry Data Type)

STDistance (geometry Data Type)

STEndpoint (geometry Data Type)

STEnvelope (geometry Data Type)

STEquals (geometry Data Type)

STExteriorRing (geometry Data Type)

STGeometryN (geometry Data Type)

STGeometryType (geometry Data Type)

STInteriorRingN (geometry Data Type)

STIntersection (geometry Data Type)

STIntersects (geometry Data Type)

STIsClosed (geometry Data Type)

STIsEmpty (geometry Data Type)

STIsRing (geometry Data Type)

STIsSimple (geometry Data Type)

STIsValid (geometry Data Type)

STLength (geometry Data Type)

STNumCurves (geometry Data Type)

STNumGeometries (geometry Data Type)

STNumInteriorRing (geometry Data Type)

STNumPoints (geometry Data Type)

STOverlaps (geometry Data Type)

STPointN (geometry Data Type)

STPointOnSurface (geometry Data Type)

STRelate (geometry Data Type)

STSrid (geometry Data Type)

STStartPoint (geometry Data Type)

STSymDifference (geometry Data Type)

STTouches (geometry Data Type)

STUnion (geometry Data Type)

STWithin (geometry Data Type)

STX (geometry Data Type)

STY (geometry Data Type)

Minimize

This topic has not yet been rated - Rate this topic

STIsEmpty (geometry Data Type)

SQL Server 2012

Returns 1 if a geometry instance is empty. Returns 0 if a geometry instance is not empty.

.STIsEmpty ( )

SQL Server return type: bit

CLR return type: SqlBoolean

The following example creates an empty geometry instance and uses STIsEmpty() to test whether the instance is empty.

DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POLYGON EMPTY', 0);
SELECT @g.STIsEmpty();

Other Resources

OGC Methods on Geometry Instances

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.