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 vote119 views1 answer
Mysql bind-address default value
SQL
12 votes99 views4 answers
Mysql version
SQL
14 votes121 views3 answers
Inner join sql oracle
SQL
8 votes105 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote105 views1 answer
Grant access on table in oracle
SQL
0 vote97 views1 answer
Sql show all users
SQL
0 vote108 views1 answer
Write sql query to show the details start from digit
SQL
0 vote105 views1 answer
Sql column as header
SQL
0 vote107 views1 answer
Mysql beautifier terminla
SQL
15 votes109 views3 answers
Mysql update add to existing value
SQL