How to Split Query Window in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 13

Scenario:

You have written long TSQL script in SSMS. You are in process of debugging and want to take a look on start and end of code at the same time. You don't have two monitor available. Is it possible if I can split window to see the same code and take a look in different parts of code at same time?

Solution:

SQL Server Management Studio (SSMS) does provide the facility to split Query window so you can take a look at different parts of code.
You will see a small button at Right Upper Corner in your query window as shown below.

How to split single windows in SSMS for debugging - SQL Server Tutorial 



Press the button and drag it down and you will see the single window will split into two windows and now you can scroll in them independently.

How to Split Single Window in SSMS - SQL Server Tutorial



Now you can take a look into different parts of same code at the same time. To remote the split. 
Go to Windows and Click Remove Split.
Split Query window into two Windows for Debugging in SSMS - SQL Server Tutorial


8 comments:

  1. GreeneJune 25, 2020 at 3:49 AM

    zc

    ReplyDelete
  2. Cynthia BoydJune 25, 2020 at 4:51 AM

    This comment has been removed by the author.

    ReplyDelete
  3. Cynthia BoydJune 25, 2020 at 4:53 AM

    Thanks to share these top branding company details it’s truly nice.

    ReplyDelete
  4. Brazilian knivesJune 25, 2020 at 5:14 AM

    The superb highly informative blog I’m about to share this with all my contacts.
    web design agency San Francisco

    ReplyDelete
  5. thomas johnJanuary 19, 2021 at 8:43 PM

    Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. Ramen Leuven

    ReplyDelete
  6. CuzToxMay 13, 2021 at 10:05 AM

    This isn't an issue in case you're intending to paint or fake completion the shaft. custom window coverings

    ReplyDelete
  7. usamaJune 7, 2021 at 1:09 AM

    Wow, excellent post. I'd like to draft like this too - taking time and real hard work to make a great article. This post has encouraged me to write some posts that I am going to write soon. spunlace nonwoven

    ReplyDelete
  8. jonJune 10, 2021 at 12:50 PM

    Really I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. check this link

    ReplyDelete

Subscribe to: Post Comments (Atom)