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

0 vote348 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote343 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
2 votes357 views1 answer
Oracle find unusable indexes
SQL
1 vote377 views3 answers
Nth highest salary
SQL
1 vote400 views2 answers
Mysql update LAST_INSERT_ID()
SQL
1 vote331 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote373 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote409 views1 answer
Sql ssrs
SQL
3 votes378 views2 answers
Sql end of month
SQL
0 vote380 views1 answer
Nvl2 syntax
SQL