STDifference (geography Data Type)
Returns an object representing the points from one geography instance that do not lie within another geography instance.
Syntax
.STDifference ( other_geography )
Arguments
- other_geography
Is another geography instance indicating which points to remove from the instance on which STDifference() is being invoked.
Return Types
SQL Server return type: geography
CLR return type: SqlGeography
Remarks
This method always returns null if the spatial reference IDs (SRIDs) of the geography instances do not match.
Examples
The following example uses STDifference() to compute the difference between two geography instances.
DECLARE @g geography;
DECLARE @h geography;
SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);
SET @h = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
SELECT @g.STDifference(@h).ToString();