Check if sql temp table exists

Sql server check if temp table exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results

Source: stackoverflow.com

Check if sql temp table exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL
    Truncate TABLE #Results
else
    CREATE TABLE #Results
    (
        Company             CHAR(3),
        StepId              TINYINT,
        FieldId             TINYINT,
    )

Source: stackoverflow.com

Similar codes

5 votes228 views1 answer
Oracle get ddl
SQL
0 vote214 views1 answer
Sqlite explain plan
SQL
1 vote217 views1 answer
Retrieve meaning
SQL
2 votes239 views5 answers
Tablespace ORACLE
SQL
1 vote221 views1 answer
Postgresql datetrunc too slow
SQL
0 vote233 views1 answer
Print intervals of 15 minutes in sql query
SQL
3 votes203 views4 answers
Mysql decimal
SQL
0 vote290 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote236 views1 answer
Wordpress make wp user in db
SQL
27 votes340 views3 answers
Mysql delete row
SQL