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 vote376 views1 answer
Enable outgoing remote MySQL access
SQL
3 votes366 views1 answer
Postgres add not null to existing column
SQL
12 votes333 views3 answers
Duplicate a column in sql
SQL
0 vote371 views1 answer
Make parameters nullable in sql server
SQL
24 votes343 views4 answers
How to add column sql
SQL
0 vote363 views1 answer
Every Derived yable must have its own alias
SQL
1 vote376 views2 answers
Foreign key set 0
SQL
3 votes344 views2 answers
Sql random integer
SQL
3 votes349 views2 answers
Mysql select database
SQL
0 vote366 views2 answers
Update information in a mysql column
SQL