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

1 vote169 views1 answer
Import sql file mysql commadn line
SQL
6 votes175 views4 answers
Eloquent to sql with bindings
SQL
0 vote206 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote172 views1 answer
Sql server epoch to datetime
SQL
6 votes173 views2 answers
Can't connect to local mysql server through socket
SQL
7 votes173 views1 answer
Postgres base size
SQL
0 vote164 views1 answer
Drop all tables db2
SQL
1 vote178 views1 answer
Sql pick random row
SQL
0 vote181 views1 answer
Oracle table privileges
SQL
0 vote231 views1 answer
Sqlite display data in separated columns
SQL