SQL Tips Don't type field names in SSMS

Here is a very handy shortcut to save lots of time when writing SQL.

I used to type out column names or use the IntelliSense features to predict them, then I discovered this shortcut.

Just drag from 'columns' in the editor and management studio automatically fills in each column name separated by commas

This could have saved me many hours if I had known this earlier, hope you find it useful

#SQL #SQLTips #SelectDistinct

Visit our page for more

[katrush]

Another simple way is just to user SELECT * FROM