Export (0) Print
Expand All

STStartPoint (geography Data Type)

Returns the start point of a geography instance.

Applies to: SQL Server (SQL Server 2008 through current version), Windows Azure SQL Database (Initial release through current release).

.STStartPoint ( )

SQL Server return type: geography

CLR return type: SqlGeography

Open Geospatial Consortium (OGC) type: Point

STStartPoint() is the equivalent of STPointN(1).

The following example creates a LineString instance and uses STStartPoint() to retrieve the start point of the instance.

DECLARE @g geography;
SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
SELECT @g.STStartPoint().ToString();
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft