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 vote277 views1 answer
Arithmetic expression in sql
SQL
1 vote256 views1 answer
Oracle user last connected
SQL
5 votes262 views4 answers
Sql check
SQL
5 votes269 views1 answer
Oracle generate list of dates in between a date range
SQL
2 votes269 views2 answers
How to view created temporary tables in mysql
SQL
0 vote266 views1 answer
Mysql get last 2 month data
SQL
3 votes253 views1 answer
Pl sql check if variable is empty
SQL
0 vote237 views1 answer
Print sum of values sql
SQL
0 vote256 views1 answer
Renommer table sql
SQL
3 votes283 views2 answers
Install mysql powershell
SQL