Question: 4. what are the differences between local and global temporary tables?
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.