A SSMs Query window is a session
Verify with local temp table:
Local temporary tables are visible only in the current session, and global temporary tables are visible in all sessions.
The name of the local temporary table is preceded by a number character (#table_name), and the name of the global temporary table is preceded by two number characters (# #table_name).
Open a Query window, create a new local temporary table, insert data, and query
Create Table int Identity Primary key, name nvarchar (ten) null); Go into Values ('mark '), (' test '); GoSelect from #temptable
And then the new Query window,
SELECT * FROM #temptable
What is this for?
These two SSMS query windows are two sessions?
sp_who view, speak with the facts:
52,53 that's the SPID, and I'm not cutting it complete.
The SPID is the session ID, the session ID is different, that is two sessions!