What is the Difference Between a Local and a Global Temporary Table in SQL Server ?

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.

A global temporary table remains in the database permanently, but the rows exist only within a given connection. When the connection is closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when a database is opened next time.



You May Interest

Adding Columns to a Table with a Query in MS SQL

What is The Difference Between The Index Seek and Index Scan in S ...

What are Table Valued Parameters ?

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

What are Isolation Levels in SQL Server ?