• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

Split screens in Microsoft SQL Server Management Studio

Hi,

Can I have a split screen to show the results of more than one query?

When I select split screen from the Window menu it splits the query screen, not the results screen. What I need is to see the result of each query I execute side by side or on top of each other in order to compare them.

Thanks
0
adamtrask
Asked:
adamtrask
  • 2
1 Solution
 
Ross TurnerManagement Information Support AnalystCommented:
I know there's support in SQL studio 2012 for true split screen.

However  you could always open a second instance of SQL studio and stick it on your second monitor to run the query. if you are running window 7 and it's pinned to your taskbar just hold shift and click the icon and it will open a second Sql Studio.

Two SSMS open on different screens
0
 
Ioannis ParaskevopoulosCommented:
Hi,

If i understand your question correctly,

if you run two 'SELECTs' simultaneously it will have the results one on top of an other. Please see the attached.

Giannis
SplitResultScreen.JPG
0
 
adamtraskAuthor Commented:
Thank you  jyparask... this was the answer I was looking for
0
 
adamtraskAuthor Commented:
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now