SQL Database Concepts Question:
Please differentiate between a Local and a Global temporary table?
Answer:
- A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
- Global temporary tables (created with a double “##”) are visible to all sessions.
- Global temporary tables are dropped when the session that created it ends, and all other sessions have stopped referencing it.
- Global temporary tables (created with a double “##”) are visible to all sessions.
- Global temporary tables are dropped when the session that created it ends, and all other sessions have stopped referencing it.
| Previous Question | Next Question |
| What is ETL - Extraction, Transformation, and Loading? | Can you explain different types of Locks in SQL Server? |