How to Display Query and Results in Separate Tab in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 15

Scenario:

Every time I run query in SQL Server Management Studio (SSMS), the results are shown under the query window. To see the full result window, I have to drag up. Can I see the Query and Results in separate Tabs in SSMS?

Solution:

To see the Result Windows in separate tab, you will be going to Options as shown below.
How to see results in separate tab in SSMS - SQL Server Tutorial

Go to Query Results, Then SQL Server and then Results to Grid and check the Check Box
Display results in separate Tab
and Switch to results tab after the query executes
How to see results in separate tab in SQL Server Management Studio - SQL Server Tutorial



Now If you open a new query window and execute TSQL query, you will see the results window as separate tab as shown below.

How to see results in separate Tab in SSMS - SQL Server Tutorial Step by Step


I noticed one thing, If you right click on table and choose Select top 100 rows , you will see the query and results as you normal do in SSMS. It will not show the results in separate Tab. To do that you have to open new query and paste your query and execute.