View many spatial layers using UNION ALL

MS-SQL 2008. View many spatial layers using UNION ALL

Example of query that shows together 3 spatial data layers. Layers represents polyline, polygon and point objects:

USE milano
GO

select id, name, g AS geo
from dbo.milano_str

UNION ALL

select id, name, g AS geo
from dbo.milano_reg

UNION ALL

select id, name, g.STBuffer(10) AS geo
from dbo.milano_pnt;

Spatial Results view in SQL Managemnt Studio:

sqlexamples.info