In Notepad++, I can look at the same file in two side-by-side tab groups. In that software, this feature is called "Clone to Over View". Is it possible to do this in SQL Sever Management Studio 2014?
To my knowledge SQL Server Studio doesn't have a clone/compare feature. Having said that, it appears that SoftTree makes a product that integrates into SQL Server Studio allowing you to use Notepad++ as the editor (which looks very cool):
Note: I have zero affiliation or investment with this company.
SoftTree looks to be a bit pricy. However, you can get a free plugin to run SQL code from Notepad++ here (I'm liking they way this looks and may have to try it myself):
You can do something similar but different.
- Open the file you want to view
- Open a new query tab
- Right click on the new query tab and select "New Vertical Tab Group"
- Copy/paste the contents of the original file you opened into the new tab
Instead of looking at the same file in two tabs, you will essentially be creating another file that you can save or not. Just be careful which file you are making modifications to, if required.
There is a second option, but to my knowledge, it only works horizontally and in the same tab - the split tab feature in SSMS.
If you click and drag the split tab icon shown above, you can create a split view of the file you are working with. Again, this only works horizontally, but is another option for you.