Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ToString (geometry Data Type)

Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a geometry instance augmented with any Z (elevation) and M (measure) values carried by the instance.

.ToString ()

SQL Server return type: nvarchar(max)

CLR return type: SqlString

This method will return the string "Null" when called on null instances.

On non-null instances, this method is equivalent to using AsTextZM().

The following example create a LineString instance and uses ToString() to fetch the text description of the instance.

DECLARE @g geometry;
SET @g = geometry::STGeomFromText('LINESTRING(0 0, 0 1, 1 0)', 0);
SELECT @g.ToString();

Community Additions

© 2015 Microsoft