在sql文中利用"@g.STDisjoint"进行多边形关系运算,即可检索出与圆形或方形多边形相关的多边形。
Sql文的原型是:
select g1,g2, g1.STDisjoint(g2) as result from (select t1.geoloc as g1, t2.geoloc as g2 from table t1, table t2) temp
在sql文中利用"@g.STDisjoint"进行多边形关系运算,即可检索出与圆形或方形多边形相关的多边形。
Sql文的原型是:
select g1,g2, g1.STDisjoint(g2) as result from (select t1.geoloc as g1, t2.geoloc as g2 from table t1, table t2) temp