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

1 vote322 views3 answers
Psql fatal database does not exist
SQL
2 votes358 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote339 views1 answer
Table or view does not exist
SQL
0 vote325 views1 answer
Criteria builder select subset of column
SQL
11 votes324 views2 answers
Having in sql
SQL
1 vote330 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
-1 vote358 views1 answer
Create view in mysql workbench
SQL
0 vote366 views1 answer
Mysql order by rand limit 1 really slow
SQL
8 votes355 views2 answers
Mysql get first x characters
SQL
0 vote328 views4 answers
Database stuck at restoring state
SQL