STIntersection (geometry)#
Returns
Syntax#
.STIntersection ( other_geometry )
Arguments#
other_geometry
Is another geometry instance to compare with the instance on which STIntersection() is being invoked, to determine where they intersect.
Return type#
geometry
Remarks#
STIntersection() always returns null if the spatial reference IDs (SRIDs) of the geometry instances do not match. The result may contain circular arc segments only if the input instances contain them.
Example#
Use STIntersection() to compute the intersection of two polygons.
DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))', 0);
SET @h = geometry::STGeomFromText('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))', 0);
SELECT @g.STIntersection(@h).ToString();