instance with an inscribed Polygon instance
queries #tsql#queries
The following example uses
to compute the symmetric difference of two
instances.
The following example returns a
that represents the symmetric difference
between a
and a.
The following example returns a
instance with an interior
ring that
represents the symmetric difference between the two instances compared.
OGC Methods on Geometry Instances
See Also
STSymDifference()
Polygon
GeometryCollection
CurvePolygon
Polygon
CurvePolygon
Polygon
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.STSymDifference(@h).ToString();
DECLARE
@g geometry =
'CURVEPOLYGON (CIRCULARSTRING (0 -4, 4 0, 0 4, -4 0, 0 -4))'
;
DECLARE
@h geometry =
'POLYGON ((1 -1, 5 -1, 5 3, 1 3, 1 -1))'
;
SELECT
@h.STSymDifference(@g).ToString();
DECLARE
@g geometry =
'CURVEPOLYGON (CIRCULARSTRING (0 -4, 4 0, 0 4, -4 0, 0 -4))'
;
DECLARE
@h geometry =
'POLYGON ((1 -1, 2 -1, 2 1, 1 1, 1 -1))'
;
SELECT
@h.STSymDifference(@g).ToString();