STMPointFromText (geometry Data Type)
Returns a geometry 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.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
The following example uses STMPointFromText() to create a geometry instance.
DECLARE @g geometry; SET @g = geometry::STMPointFromText('MULTIPOINT ((100 100), (200 200))', 0); SELECT @g.ToString();