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)
http://www.techbrothersit.com/
Видео How to Display Query and Results in Separate Tab in SSMS - SQL Server / T-SQL Tutorial Part 15 канала TechBrothersIT
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)
http://www.techbrothersit.com/
Видео How to Display Query and Results in Separate Tab in SSMS - SQL Server / T-SQL Tutorial Part 15 канала TechBrothersIT
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Self Hosted Integration Runtime Auto Upgrade is not Working in Azure Data Factory Tutorial 2021](https://i.ytimg.com/vi/iKXTtzaCZFE/default.jpg)
![SSRS Tutorial Part 119.2 - How to Create Map Reports in SSRS (Map Gallery- Bubble Map)](https://i.ytimg.com/vi/XJ7SF8tg5E8/default.jpg)
![How to read Cell Value from Excel by using Script Task in SSIS Package-P176](https://i.ytimg.com/vi/fIK2rUd-jX4/default.jpg)
![SSRS Tutorial 43 - How to change Color of Alternative Row in SSRS Report](https://i.ytimg.com/vi/j-bCd_p4VvQ/default.jpg)
![How to find installed Features in windows 8.1](https://i.ytimg.com/vi/Rp0wWER8xxk/default.jpg)
![How to Convert Parquet File to CSV File in Azure Data Factory | Azure Data Factory Tutorial 2022](https://i.ytimg.com/vi/swUCbZMqaUk/default.jpg)
![How to Use Switch Activity in Azure Data Factory - Azure Data Factory Tutorial 2021 - ADF Tutorial](https://i.ytimg.com/vi/qOYk0J0ucIM/default.jpg)
![How to upgrade GCP MySQL Instance by using Database Migration Service-Reduce GCP MySQL Instance Disk](https://i.ytimg.com/vi/Jj59ABUG240/default.jpg)
![SSIS Tutorial Part 83-Create file with Date From SQL Server Table & Send as Attachment SSIS Package](https://i.ytimg.com/vi/QGgIC2f8f9Y/default.jpg)
![SSIS Interview Questions Answers | How would you group the Tasks in SSIS Package](https://i.ytimg.com/vi/d8QtN1WYiLo/default.jpg)
![Load Data To Tables according to Excel Sheet Names from Excel Files dynamically in SSIS Package-P161](https://i.ytimg.com/vi/wUxpc0CruSo/default.jpg)
![SSRS Tutorial 17 - Create Block Group Report with Sub Total and Grand Total from Basics](https://i.ytimg.com/vi/kJXmGRT10wg/default.jpg)
![SSIS Tutorial Part 13-Create Comma Delimited File with DateTime from SQL Table in SSIS Package](https://i.ytimg.com/vi/d3H8frvzNzs/default.jpg)
![SSRS Tutorial 15 - Create Detail/Tabular Report from Basics in SQL Server Reporting Services](https://i.ytimg.com/vi/Cap3tUiQUCQ/default.jpg)
![How to Install SQL Server 2016 Master Data Services MDS Step by Step - SQL Server 2016 DBA Tutorial](https://i.ytimg.com/vi/eQ1SwWxVs-8/default.jpg)
![Does Copy Activity Supports UPSERT Operation | Azure Data Factory Interview Questions 2022](https://i.ytimg.com/vi/TCPSf8Jjb9M/default.jpg)
![Kusto Limit Operator and Take Alias | Kusto Query Language Tutorial (KQL)](https://i.ytimg.com/vi/-Dm7vJawYBc/default.jpg)
![SSRS Tutorial 12 - Understand Page,Group and Detail in Report Wizard](https://i.ytimg.com/vi/8Zjd2gTrmug/default.jpg)
![Split Function in Kusto Query (KQL) How to split string into values in Kusto Query Language - 2022](https://i.ytimg.com/vi/n5CPoKM0DKQ/default.jpg)
![SSRS Tutorial 05 - Intro to Embedded Data Sets and Shared Data Sets in SQL Server Reporting Services](https://i.ytimg.com/vi/HVTMJQbbZok/default.jpg)
![How to Disable All the Triggers in SQL Server Database - SQL Server Tutorial](https://i.ytimg.com/vi/sDT7imtgD7k/default.jpg)