SQL Server Tips & Tricks Part - 1

Click here or below for you tube Answer https://youtu.be/zq6IEqJKnGk

Tip 1: Key board Shortcut to open Object Explorer

           Press F8 button to open Object Explorer

Tip 2: Key board Shortcut to Open New Query Editor window (Ctrl + N)

           Press Ctrl + N to open New query editor Window

Tip 3: Easy ways to Select your Queries

           Simply select the queries using mouse

           Place your cursor on the border of query editor on the left pane the arrow runs right side

           Place cursor at the end of the query and press Shift + Up arrow

Tip 4: Shift rows to Right or Left

          To move rows to Right, Select queries and Press Tab

          To move rows to Left, Select queries and Press Shift+ Tab

Tip 5: Key board Shortcut to Hide/show Result set

          To Hide Result set press Ctrl + R

          Press Ctrl + R to show the Result set

Tip 6: Writing/editing vertically for multiple rows

          Place the cursor at the starting of the query

          Then hold Alt button and click and hold left button of mouse

Tip 7: How to add a break point in SQL Server?

          Click on the Left Grey pane to add a break point

Tip 8: New Vertical Tab Group for Comparison

          Right Click on the top of the query window title

          Select “New Vertical Tab Group” & two query editor windows shown vertically

          Right Click on one of the window title and press “Move to Previous Group Tab”

Tip 9: New Horizontal Tab Group for Comparison

         Right Click on the top of the query window title

         Select “New Horizontal Tab Group” & two query editor windows shown vertically

         Right Click on one of the window title and press “Move to Previous Group Tab”

Summary: