A while ago I had been playing a bit with the new spatial data types in SQL Server 2008. Not only can SQL Server store such data, it can also visualize it. So I had come up with the following query:
select geometry::STPolyFromText
('POLYGON((1 1, 1.5 1.85, 2.5 1.85, 3 1, 2.5 0.15, 1.5 0.15, 1 1),
(1.5 [...]
Click here to see the original post