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