SQL Server Tips & Tricks Part - 2

Click here or below for you tube Answer

Tip 1: Tip 1: Shuffle/Move Result set Columns post querying in SSMS

           --> 1.1 -- Execute the Query

           --> 1.2 – Left click + drag the title of the column in the result grid

           --> 1.3 – Drag it to the position you want to move


Tip 2: Key Board Shortcut for Writing/editing vertically for multiple rows

           --> 2.1 –- Mouse Short Cut – ALT + Left Click + Drag

           --> 2.2 -- Key Board Short Cut – ALT + Shift + Arrow Keys

           --> 2.3 – Useful when appending commas or quotes for values