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

4 votes385 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote333 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote393 views1 answer
Install mysql on bash
SQL
0 vote330 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes363 views1 answer
Sqlplus clear screen
SQL
-1 vote356 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
6 votes323 views1 answer
How to count number of rows in sql
SQL
18 votes330 views6 answers
Mysql create table
SQL
1 vote337 views1 answer
Oracle create as select
SQL
3 votes361 views3 answers
Stop mysql ubuntu
SQL