MSSQL 2000 – Select Column

Anyone know how to use a SQL stmt to auto retrieve the first and second column from a table
(any table)

Select … , … from Orders etc

is there column(1) function ?