Sometimes you want to select all the columns, without using the *. Specifying column names speeds up your query. The problem comes in with large tables or tables with difficult column names.
Solution:
Type SELECT
Click the + next to the desired table in the Object Explorer
Drag the Columns folder to the query pane
Complete your query by including the FROM, the table name and conditions
This gives you a nicely comma-separated list of column names.
Visit the DevX Tip Bank
