View affect of Script before COMMIT in another Window
You can use Table Hints such as WITH (NOLOCK) or WITH (READUNCOMMITTED) to perform dirty reads of uncommitted data between two windows in SSMS.
View data stored in #TempTable from another Window
You can use global temporary tables (##Table instead of #Table) to query temporary tables across sessions. ...
If I'm doing something wrong or missing some Point please let me know.
You're not missing anything. SSMS always has a separate session per tab.
it's SUCH a pain to run a script... and then from that same tab have
to then write in other code when I don't want to edit/add any other
code to the page that contains the script I ran.
In SSMS the Execute ...