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 votes311 views3 answers
Sql current year
SQL
0 vote336 views1 answer
How to add boolean column in postgresql
SQL
0 vote309 views1 answer
Psql no such file or directory
SQL
0 vote304 views1 answer
Procedures and functions in pl/sql
SQL
18 votes275 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote333 views1 answer
Jooq convert using gbk
SQL
0 vote345 views1 answer
Will graphql replace sql
SQL
0 vote323 views1 answer
Create table sql generator
SQL
0 vote310 views1 answer
Update table sql multiple set
SQL
5 votes336 views3 answers
Bash: mysql: command not found
SQL