Mar 29, 2009 at 5:51 PM
Edited Mar 29, 2009 at 6:04 PM
Apparently Microsoft implemented a lot of the methods from the Open Geospatial Consortium.  To me several methods implemented by SQL Server's OGC on Geometry Instances will be useful in creating a topology.  In particular the following methods seemed useful:
Example of use of STIntersects from SQL Server Spatial Support: An Introduction by Isaac @ MSDN:
I.e., geography is a column type just like any other.  We expose a pretty comprehensive set of operations on these type through a method-based interface.  For example, if we have a geometry variable @microsoft that represents Microsoft’s main campus, we can find out which roads intersect it with the query:
FROM Roads
WHERE location.STIntersects(@microsoft) = 1