Question: what is the difference between a local temporary table and a global temporary table?
Answer: Local temp tables are only available to the SQL Server session or connection (means single user) that created the tables. ... A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection is closed, the data in the global temporary table disappears.