Create temp table in sql

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

Source: stackoverflow.com

Temp tables in sql server

DECLARE @TempTable AS TABLE(//Mention your columns in here.//)
After that you can insert into this table later.

Create temporary table sql

-- CREATE TEMP TABLE 
Create Table #MyTempTable (
    EmployeeID int
);
-- DROP TEMP TABLEIF OBJECT_ID('tempdb..#MyTempTable') IS NOT NULL DROP TABLE #MyTempTable

-1

Similar codes

3 votes124 views1 answer
Postgresql where current year
SQL
11 votes185 views2 answers
Set default column value sql
SQL
0 vote160 views2 answers
Sql searching via key word
SQL
-1 vote153 views1 answer
Mysql #1064 error
SQL
1 vote150 views2 answers
Sql select only first occurrence
SQL
0 vote180 views1 answer
Sql today at midnight
SQL
0 vote159 views1 answer
Mysql_union
SQL
6 votes165 views1 answer
SQL insert all columns
SQL
0 vote169 views2 answers
Update query with between in mysql
SQL
1 vote225 views1 answer
Mysql is odd
SQL