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 votes224 views3 answers
Sql interview query questions
SQL
5 votes212 views2 answers
Mysql import gzip db
SQL
0 vote233 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote202 views1 answer
Create sqlite database in laravel
SQL
17 votes207 views5 answers
Order by sql
SQL
-1 vote210 views1 answer
How to create foreign key in sql server management studio
SQL
53 votes385 views6 answers
How to install mysql ubuntu
SQL
0 vote203 views2 answers
Oracle create chain rule
SQL
0 vote229 views1 answer
How do I insert a blob in SQL?
SQL
3 votes219 views2 answers
Mysql select database
SQL