dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Selecting All Columns, Separated with Commas

See how to get a nicely comma-separated list of column names.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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

 





   
Thanks for your registration, follow us on our social networks to keep up-to-date