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 votes316 views3 answers
Row number mysql
SQL
0 vote291 views1 answer
If column value is null then in mysql
SQL
0 vote318 views1 answer
Distance calculator from lat long sql query
SQL
5 votes295 views1 answer
Mysql last day of next month
SQL
0 vote284 views1 answer
Sql select inside select sub query
SQL
8 votes270 views2 answers
Phpmyadmin password
SQL
0 vote287 views1 answer
Sql trying to delete database in use
SQL
0 vote280 views1 answer
Inner join distinct
SQL
0 vote275 views1 answer
Call function sql oracle
SQL
1 vote272 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL