Temporary Tables : Temporary Table « Table « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Table
  3. Temporary Table
Each temporary table is implicitly dropped by the system.
Each temporary table is stored in the tempdb system database.

Temporary tables can be local or global. 
Local temporary tables are removed at the end of the current session. 
They are specified with the prefix #table_name. 
Global temporary tables, which are specified with the prefix ##, are dropped at the end of the session that created this table.


CREATE TABLE #project_temp
        (project_no CHAR(4) NOT NULL,
        project_name CHAR(25) NOT NULL)

SELECT project_no, project_name
       INTO #project_temp1
       FROM project








3.7.Temporary Table
3.7.1.Temporary Tables
3.7.2.Local temporary Table
3.7.3.Using a Temporary Table to Communicate with an EXEC()
3.7.4.A script that creates a global temporary table of random numbers
3.7.5.A script that uses a local temporary table instead of a derived table
3.7.6.SELECT INTO a temporary table
3.7.7.Creating a Table with Duplicate Rows
3.7.8.A global temporary table's name begins with ##.
3.7.9.Creating a Local Temporary Table with a SELECT INTO