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

0 vote229 views1 answer
Postgresql alter table sequence
SQL
0 vote144 views1 answer
Java spring jdbc connect to postgresql
SQL
3 votes182 views2 answers
Oracle grants
SQL
1 vote172 views1 answer
Sql delete row with auto increment
SQL
4 votes211 views4 answers
Mysql get date from datetime
SQL
1 vote202 views1 answer
Sqlite update from another table
SQL
0 vote191 views1 answer
Mysql root permission denied lost
SQL
-2 votes190 views1 answer
Create trigger syntax
SQL
1 vote223 views1 answer
Find difference in dates sql
SQL
0 vote219 views1 answer
Insert output identity
SQL