函数 STContains
作用: 是否有包含的空间关系
DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON ((105.28647000000007 28.164760000000058,105.28647000000007 32.20336000000003,110.19387000000006 32.20336000000003,110.19387000000006 28.164760000000058,105.28647000000007 28.164760000000058))', 4326)
SET @h = (select shape from table1 where gb like '500110')
SELECT @g.STContains(@h);
注意:这个函数被包含的图形应该作为STContains的参数来使用
函数 STOverlaps
作用: 是否有相交的空间关系
DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON ((105.28647000000007 28.164760000000058,105.28647000000007 32.20336000000003,110.19387000000006 32.20336000000003,110.19387000000006 28.164760000000058,105.28647000000007 28.164760000000058))', 4326)
SET @h = (select shape from table1 where gb like '500110')
SELECT @g.STOverlaps(@h);