Create temporary table sql

Create temp table in sql

-- CREATE TEMP TABLE 
Create Table #MyTempTable (
    EmployeeID int
);

Source: stackoverflow.com

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

1 vote225 views1 answer
Stop mysql server mac
SQL
0 vote247 views1 answer
Get date ISO in psql
SQL
-1 vote224 views3 answers
Mysql get age from date
SQL
1 vote246 views1 answer
Sql server today minus n
SQL
0 vote269 views2 answers
How to get max from each department in sql
SQL
0 vote266 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
1 vote265 views1 answer
Oracle see column type
SQL
0 vote227 views1 answer
Sql database size
SQL
0 vote236 views1 answer
Sql server query database space available
SQL
0 vote266 views1 answer
Mysql insert multiple rows based on select
SQL