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 vote139 views1 answer
Mysql server not running
SQL
1 vote97 views1 answer
Unique vs distinct sql
SQL
0 vote138 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote152 views1 answer
Load data infile mariadb slow
SQL
0 vote149 views1 answer
Sql describe
SQL
0 vote144 views1 answer
Sql query for login with email or username
SQL
1 vote128 views1 answer
How to see logical reads in sql server
SQL
0 vote102 views1 answer
Query for maximum salary
SQL
1 vote140 views1 answer
Display total number of tables in mysql
SQL
0 vote130 views1 answer
Wp_query raw sql
SQL