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 votes202 views1 answer
Mac install mysql
SQL
0 vote200 views1 answer
T-sql check if data exists
SQL
4 votes191 views2 answers
How to delete row in sql
SQL
0 vote258 views1 answer
Sql server python connection
SQL
0 vote229 views1 answer
Mysql last friday of current month
SQL
2 votes203 views2 answers
Laravel query builder toSql
SQL
1 vote206 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote188 views1 answer
Sqldf change user
SQL
0 vote237 views2 answers
Php convert dbf to mysql
SQL
0 vote194 views1 answer
Psql initialization
SQL