STPointFromText (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 STPointFromText() to create a geometry instance.
DECLARE @g geometry; SET @g = geometry::STPointFromText('POINT (100 100)', 0); SELECT @g.ToString();