t8qCmZAF

1----------------------------------------------------------------------
2-- Type of Temp tables
3----------------------------------------------------------------------
4CREATE TABLE #TEMPTABLE -- It exists only in session.
5(	 Column1 int );
6
7CREATE TABLE ##TEMPTABLE -- It exists all sessions.
8(	 Column1 int );
9
10DECLARE @TEMPTABLE TABLE -- It exists only when the command is executed
11(	 Column1 int );
12
13SELECT * FROM ##TEMPTABLE
14SELECT * FROM #TEMPTABLE
15SELECT * FROM @TEMPTABLE;
16
17-- SELECT INTO in a new temp tables
18SELECT 1 as Val1 INTO #TEMPTABLE1 -- FROM TABLE
19SELECT 1 as Val1 INTO ##TEMPTABLE1 -- FROM TABLE
20WITH DOC AS (SELECT	 1 AS VAL1) -- Similar variable table type
21SELECT * FROM DOC
22-- Clear temp database
23IF OBJECT_ID('tempdb..#TEMPTABLE1', 'U') IS NOT NULL
24	DROP TABLE #TEMPTABLE1