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 vote188 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote273 views2 answers
Fanyi
SQL
5 votes201 views6 answers
In operator sql
SQL
0 vote220 views1 answer
Connecting mySQL to STS
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
0 vote188 views1 answer
Backup a table in sql
SQL
4 votes202 views1 answer
Oracle error line
SQL
1 vote194 views1 answer
Cross schema query oracle 2 users
SQL
0 vote186 views2 answers
Mysql two column combination unique
SQL
0 vote213 views2 answers
Get item by composite primary key mysql
SQL