TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

STPointOnSurface (geometry Data Type)

 

Returns an arbitrary point located within the interior of a geometry instance.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
  
.STPointOnSurface ( )  

SQL Server return type: geometry

CLR return type: SqlGeometry

Open Geospatial Consortium (OGC) type: Point

This method returns null if the instance is empty.

The following example creates a Polygon instance and uses STPointOnSurface() to find a point on the instance.

DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('POLYGON((0 0, 3 0, 3 3, 0 3, 0 0),(2 2, 2 1, 1 1, 1 2, 2 2))', 0);  
SELECT @g.STPointOnSurface().ToString();  

OGC Methods on Geometry Instances

Community Additions

ADD
Show:
© 2016 Microsoft