MS SQL Server: GLOBAL TEMPORARY TABLE in SQL Server

The global temporary table Global Temporary Table in SQL Server (Transact-SQL) are tables created separately in SQL Server sessions,

Syntax

 CREAT E TABLE ##ten_bang 
 ( 
  cot1 kieudulieu [ NULL | NOT NULL ], 
  cot2 kieudulieu [ NULL | NOT NULL ], 
  … 
 ); 

Variable name or variable value

ten_bang

The name of the global clipboard needs to be created. The name begins with the ## character.

cot1, cot2

The column you want to create in the global clipboard. Each column must have 1 data type. The column may contain NULL or NOT NULL values. If left blank, the default is NULL.

Data types in SQL Server

Note

The name of the global clipboard is prefixed with ## (As an example, ## nhanvien)

As an example,

 CR EATE TABLE ##nhanvien 
 ( id_nhanvien INT PRIMARY KEY, 
  ho VARCHAR(50) NOT NULL, 
  ten VARCHAR(50), 
  luong MONEY 
 ); 

For this example, the CREATE TABLE command will create a global temporary table named ## name in SQL Server with 4 columns:

• nhanvien, INT data type, does not contain NULL value.
• cough, VARCHAR data type (maximum length of 50 characters) and contains no NULL value.
• ten, VARCHAR data type, can contain NULL values.
• , MONEY data type, can contain NULL values.
• Primary key PRIMARY KEY for table ## nhanvien is id_nhanvien.