# temp table sql storage duration code example

Example 1: create temp table in sql

-- CREATE TEMP TABLE 
Create Table #MyTempTable (
    EmployeeID int
);

Example 2: sql server: creating temp table by selecting records from other tables

SELECT *
INTO #
FROM 
WHERE 
ORDER BY 
OPTION