Splitting the query window in SQL Server Management Studio

Category : Tips User Rating : 4.5 Stars      Views : 4 Stars
One Click Feedback
Please help us to improve the site by rating the quality of this article by clicking a button below.




When copying data into a new table using SELECT INTO it can be useful to add an identity column Splitting the Query Window in SQL Server Management Studio SQL Server Management Studio (SSMS) has a handy feature which allows you to split a query window in two. Just hover over the small rectangular box to the top right of the window (see the picture below).


Splitting Query Window Step 1


When the cursor changes to a pair of parallel lines, click and drag the window down. The window splits into two panes.

Splitting Query Window Step 2

Each part of the window scrolls independently so you can see two parts of the same file at once. Any edits in one part of the screen get reflected in the other.

Splitting Query Window Step 3

This split pane is very useful for viewing and editing those long scripts and stored procedures !

Related Articles

The following articles may also be of interest :

Link back to this article : http://www.sqlmatters.com/Articles/Splitting the query window in SQL Server Management Studio.aspx

Keywords

SSMS,SQL Server Management Studio,query,window


Comments
Post by Dave on Wed 03 Feb 2016 17:46. Report Inappropriate Post

How do you unsplit the window?
Post by T on Tue 05 Apr 2016 16:36. Report Inappropriate Post

To unsplit, just double click the line or drag it all the way up. I wish there was also a horizontal split.
Post by Ravi on Thu 13 Oct 2016 11:21. Report Inappropriate Post

Excellent Article.Kudos and Thanks :)

Post a comment   No login required !

 
Name :   Email :   Website :  
Will be displayed alongside your comment
Not displayed Optional, but displayed if entered