SQL SERVER - Display Query and Results in a Separate tab

 SSMS: Display Query and Results in Separate Tab

With SQL Server Management Studio (2008, 2012, 2014, 2016, or latest version) we often need to adjust the results grid to view the query results in proper way or change the SQL Server query results view.

In order to display the query and results in separate tab we have few short cuts.

Step 1:

In SSMS (sql server management studio), Go to Tool  and then click on Option

Step 2:

Under Options-> Go to Query Results -> SQL Server -> Results to Grid and then Check

Display Results in a separate tab  and Switch to results tab after the query executes Check boxes 

Step 3: Now try to run the query, You will see query and results are in separate tab.