xxxxxxxxxx
-- 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;
xxxxxxxxxx
-- CREATE TEMP TABLE
Create Table #MyTempTable (
EmployeeID int
);
-- DROP TEMP TABLE
IF OBJECT_ID('tempdb..#MyTempTable') IS NOT NULL DROP TABLE #MyTempTable
xxxxxxxxxx
declare @table table (id int)
create table #table (id int)
create table ##table (id int)
select * into #table from xyz