File tree Expand file tree Collapse file tree
docs/t-sql/spatial-geometry Expand file tree Collapse file tree Original file line number Diff line number Diff line change @@ -23,36 +23,36 @@ ms.author: "rickbyh"
2323manager : " jhubbard"
2424---
2525# STIsEmpty (geometry Data Type)
26- [ !INCLUDE[ tsql-appliesto-ss2008-xxxx -xxxx-xxx_md] ( ../../includes/tsql-appliesto-ss2008-xxxx -xxxx-xxx-md.md )]
26+ [ !INCLUDE[ tsql-appliesto-ss2008-asdb -xxxx-xxx_md] ( ../../includes/tsql-appliesto-ss2008-asdb -xxxx-xxx-md.md )]
2727
28- Returns 1 if a ** geometry** instance is empty. Returns 0 if a ** geometry** instance is not empty.
29-
30- ||
31- | -|
32- | ** Applies to** : [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] ([ !INCLUDE[ ssKatmai] ( ../../includes/sskatmai-md.md )] through [ current version] ( http://go.microsoft.com/fwlink/p/?LinkId=299658 ) ), [ !INCLUDE[ ssSDSfull] ( ../../includes/sssdsfull-md.md )] .|
33-
34- ## Syntax
35-
36- ```
37-
38- .STIsEmpty ( )
39- ```
40-
41- ## Return Types
42- [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] return type: ** bit**
43-
44- CLR return type: ** SqlBoolean**
45-
46- ## Examples
47- The following example creates an empty ` geometry ` instance and uses ` STIsEmpty() ` to test whether the instance is empty.
48-
49- ```
50- DECLARE @g geometry;
51- SET @g = geometry::STGeomFromText('POLYGON EMPTY', 0);
52- SELECT @g.STIsEmpty();
53- ```
54-
55- ## See Also
56- [ OGC Methods on Geometry Instances] ( ../../t-sql/spatial-geometry/ogc-methods-on-geometry-instances.md )
57-
58-
28+ Returns 1 if a ** geometry** instance is empty. Returns 0 if a ** geometry** instance is not empty.
29+
30+ ||
31+ | -|
32+ | ** Applies to** : [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] ([ !INCLUDE[ ssKatmai] ( ../../includes/sskatmai-md.md )] through [ current version] ( http://go.microsoft.com/fwlink/p/?LinkId=299658 ) ), [ !INCLUDE[ ssSDSfull] ( ../../includes/sssdsfull-md.md )] .|
33+
34+ ## Syntax
35+
36+ ```
37+
38+ .STIsEmpty ( )
39+ ```
40+
41+ ## Return Types
42+ [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] return type: ** bit**
43+
44+ CLR return type: ** SqlBoolean**
45+
46+ ## Examples
47+ The following example creates an empty ` geometry ` instance and uses ` STIsEmpty() ` to test whether the instance is empty.
48+
49+ ```
50+ DECLARE @g geometry;
51+ SET @g = geometry::STGeomFromText('POLYGON EMPTY', 0);
52+ SELECT @g.STIsEmpty();
53+ ```
54+
55+ ## See Also
56+ [ OGC Methods on Geometry Instances] ( ../../t-sql/spatial-geometry/ogc-methods-on-geometry-instances.md )
57+
58+
You can’t perform that action at this time.
0 commit comments