Replacing * with column names the easy way

Just open Object Explorer, expand the table or view name, click on the “Columns” node and drag it onto the query window:

 

Thanks goes out to Aaron Bertrand for posting this trick on his blog:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/10/bad-habits-to-kick-using-select-omitting-the-column-list.aspx

Note: Cross posted from Rob Pellicaan IS Blog.

Permalink