see temp tables sql server code example Example: create temp table in sql -- CREATE TEMP TABLE Create Table #MyTempTable ( EmployeeID int );