If you know quantity of columns, but don't know its names and types, you can use following trick:
select NULL as C1, NULL as C2 where 1 = 0
-- Returns empty table with predefined column names
union all
select * from Test
-- There should be exactly 2 columns, but names and data type doesn't matter
As a result, you will have a table with 2 columns [C1] and [C2].
This method is not very usefull if you have 100 columns in your table, but it works well for tables with small predefined number of columns.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…