Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Syntax
.ToString ()
Return Types
SQL Server return type: nvarchar(max)
CLR return type: SqlString
Remarks
This method will return the string "Null" when called on null instances.
On non-null instances, this method is equivalent to using AsTextZM().
Examples
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();