Mitch’s Quick Tips – #5 – Easily Copy Table Columns to a Query

I was just helping someone at their desk with writing a query and showed them a trick that blew their mind… At that moment, it donned on me that I too was blown away when I was shown it. So, I figured it would be a great quick and easy tip to add to my blog.

We have all been there before where we are writing a query or Stored Procedure and need to pull all of the columns from a table into a query but always thought it was a huge hassle. Either we had to script out the table and copy them or manually type them all out or drag them all out, one by one. It was a total pain and very time-consuming. Well, have you ever thought about clicking and dragging the columns into a query analyzer screen?

ColumnClicknDrag

Yup, it is that easy and a big time saver…

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s