How to create and manage SQL Server temporary tables?
This tutorial video shows how to create and manage SQL Server temporary tables with queries.
All scripts are available on the blog :
https://expert-only.com/en/t-sql/crea...
First how to create a local temporary table, then how to insert a few rows, i.e., like in a permanent table.
Then how to list all the temp tables in a database using the tempdb.sys.sysobjects system table.
And finally how to check and drop a temporary table.
You'll notice that each temporary created in a session, i.e. each SSMS tab, have its own id and is independant from the other temp tables with the same name.