devxlogo

Selecting All Columns, Separated with Commas

Selecting All Columns, Separated with Commas

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 SELECTClick the + next to the desired table in the Object ExplorerDrag the Columns folder to the query paneComplete your query by including the FROM, the table name and conditions

This gives you a nicely comma-separated list of column names.

devx-admin

Share the Post: