Global Temporary Table in sql server
Global Temporary Table:
Global Temporary tables are visible to or available across all sessions. And all users.
Global Temporary tables are created using the same syntax as a CREATE TABLE except the table name starts with "##" (two '#' signs). When the table is only "##", it is defined as a local global temporary table and it's scope is not limited to the session it is created in.
A Global Temporary table is dropped automatically when the last session using the temporary table has completed.
Both the local temporary tables and global temporary tables are physical.
Advertising