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

2 votes323 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote338 views2 answers
Test sqlsrv connection
SQL
1 vote345 views1 answer
Mysql select and count left join
SQL
2 votes341 views1 answer
Set auto increment from 1
SQL
1 vote326 views1 answer
Sql find column name like
SQL
1 vote323 views2 answers
Setval max id postgresql sequence
SQL
1 vote320 views2 answers
Mysql current user
SQL
0 vote378 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote332 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote337 views2 answers
Postgres copy table from one schema to another
SQL