There isn't a way to do it without listing the columns unless you resort to
dynamic SQL. For reasons of reliability and ease of maintenance it's
generally a good idea to list columns by name in a query. Avoid using SELECT
* in production code. Query Analyzer lets you drag a list of column names
from the Object Browser into the query window, which can save some typing
effort.

--
David Portas
SQL Server MVP
--