How to Display Query and Results in Separate Tab in SSMS - SQL Server / T-SQL Tutorial Part 15

How to Display Query and Results in Separate Tab in SSMS - SQL Server / T-SQL Tutorial

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

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

Now If you open a new query window and execute TSQL query, you will see the results window.

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.

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)

[michaelcarini]

is there a way to make the result tab appear adjacent to the query?
like a vertical tab group where one is the query and one the result set?