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
Collapse the table of content
Expand the table of content
Expand Minimize

SqlGeography.STGeomCollFromText Method (SqlChars, Int32)


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

Namespace:   Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public static SqlGeography STGeomCollFromText(
	SqlChars geometryCollectionTaggedText,
	int srid


Type: System.Data.SqlTypes.SqlChars

Is the WKT representation of the geography instance you wish to return. geometrycollection_tagged_text is an nvarchar(max) expression.

Type: System.Int32

Is an int expression representing the spatial reference ID (SRID) of the geography instance you wish to return.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography

A geography instance.

The OGC type of the geography instance returned by STGeomCollFromText is set to the corresponding WKT input.

This method throws an ArgumentException if the input is not valid.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft