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

0 vote245 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote130 views1 answer
Executescalar in sql server
SQL
0 vote110 views1 answer
Compare two tables to find unmatched records
SQL
4 votes113 views1 answer
Oracle error line
SQL
0 vote106 views2 answers
Soql last year
SQL
0 vote128 views1 answer
Oracle job schedules
SQL
2 votes122 views3 answers
Postgresql reset auto increment
SQL
1 vote129 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote226 views1 answer
Multiple replace value mssql
SQL
0 vote127 views1 answer
Mysql type for large numbers with many decimal
SQL