--// Compatible with all version
Select Name, MiddleName, LastName
From (
Select Name = 'Blog1', MiddleName = 'Do1', LastName = 'Leandro1'
UNION
Select Name = 'Blog2', MiddleName = 'Do2', LastName = 'Leandro2'
) tbName
--// Compatible with >= 2008
Select Name, MiddleName, LastName
From (
values ('Blog1', 'Do1', 'Leandro1'),
('Blog2' , 'Do2' , 'Leandro2')
) tbName(Name, MiddleName, LastName)
Select Name, MiddleName, LastName
From (
Select Name = 'Leandro', MiddleName = 'Rodrigo', LastName = 'Buffone'
UNION
Select Name = 'Sandra', MiddleName = 'Braz', LastName = 'Buffone'
) tbName