sql server 2008 - SQL to return first two columns of a table

Question

Is there any SQL lingo to return JUST the first two columns of a table WITHOUT knowing the field names?

Something like

SELECT Column(1), Column(2) FROM Table_Name

Or do I have to go the long way around and find out the column names first? How would I do that?

Answer 1

You have to get the column names first. Most platforms support this:

select column_name,ordinal_position
  from information_schema.columns
 where table_schema = ...
   and table_name = ...
   and ordinal_position <= 2