Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
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)
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)
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)
Expand Minimize
This topic has not yet been rated - Rate this topic

STX (geometry Data Type)

The X-coordinate property of a Point instance.

Copy 

.STX

SQL Server type: float

CLR type: SqlDouble

The value of this property will be null if the geometry instance is not a point.

This property is read-only.

The following example creates a Point instance and uses STX to retrieve the X-coordinate of the instance.

Copy 
DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POINT(3 8)', 0);
SELECT @g.STX;
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.