STContains (geometry Data Type)
Returns 1 if a geometry instance completely contains another geometry instance. Returns 0 if it does not.
Applies to: SQL Server (SQL Server 2012 through current version), Azure SQL Database.
The following example uses STContains() to test two geometry instances to see if the first instance contains the second instance.
DECLARE @g geometry; DECLARE @h geometry; SET @g = geometry::STGeomFromText('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))', 0); SET @h = geometry::STGeomFromText('POINT(1 1)', 0); SELECT @g.STContains(@h);