-- Create temp table
CREATE TEMP TABLE temp_table (
id INT,
name VARCHAR(30)
);
-- Query results to store in the temporary table on the fly
CREATE TEMP TABLE temp_table AS
SELECT column1, column2
FROM table_name;
-- Insert values in temporary table from another table
INSERT INTO temp_table
SELECT column1, column2
FROM another_table
-- Delete temporary table
DROP TABLE IF EXISTS temp_table;CREATE TEMPORARY TABLE temp_table (
id INT,
name VARCHAR(50),
age INT
); -- create Local temporary table i.e single hash(#)
CREATE TABLE #TempTable
( Column1 datatype, column2 datatype……)
INSERT INTO #TempTable
(Column1, column2……)
VALUES ('value 1', 'value 2')
-- 2nd method (Select Into)
SELECT *
INTO #TempTable -- remove this part and it becomes simple select query
FROM SampleTable
WHERE...
-- create Global temporary table i.e double hash(##)
CREATE TABLE ##tablename
( Column1 datatype, column2 datatype……) -- CREATE TEMP TABLE
Create Table #MyTempTable (
EmployeeID int
);
-- DROP TEMP TABLE
IF OBJECT_ID('tempdb..#MyTempTable') IS NOT NULL DROP TABLE #MyTempTableIF Object_ID('tempdb..#Tablename') IS NOT NULL DROP TABLE #Tablename
Select
*
into
#Tablename
FROM
SampleTable-- Create a temp table for salaries
CREATE TEMPORARY TABLE temp_salaries (
employee_id INT PRIMARY KEY,
salary DECIMAL(10, 2)
);If(OBJECT_ID('tempdb..#temp') Is Not Null)
Begin
Drop Table #Temp
EndCREATE TABLE #name_of_temp_table (
column_1 datatype,
column_2 datatype,
column_3 datatype,
.
.
column_n datatype
)declare @table table (id int)
create table #table (id int)
create table ##table (id int)
select * into #table from xyzdeclare table sql server