Solved

Split screens in Microsoft SQL Server Management Studio

Posted on 2013-01-31
4
674 Views
Last Modified: 2013-01-31
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
Comment
Question by:adamtrask
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Ross Turner
ID: 38839452
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
 
LVL 23

Accepted Solution

by:
Ioannis Paraskevopoulos earned 500 total points
ID: 38839482
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
 

Author Comment

by:adamtrask
ID: 38839501
Thank you  jyparask... this was the answer I was looking for
0
 

Author Closing Comment

by:adamtrask
ID: 38839506
Thanks
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now