select * from
(select Name as 第一列 from dbo.Test where ID = 1) as c1,
(select Name as 第二列 from dbo.Test where ID = 2) as c2,
(select Name as 第三列 from dbo.Test where ID = 3) as c3
select * from
(select Name as 第一列 from dbo.Test where ID = 1) as c1,
(select Name as 第二列 from dbo.Test where ID = 2) as c2,
(select Name as 第三列 from dbo.Test where ID = 3) as c3