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 vote172 views1 answer
Mysql best tutorial for beginners
SQL
1 vote183 views1 answer
Oracle turn off constraint
SQL
1 vote176 views1 answer
How to use a trigger to validate input data
SQL
0 vote166 views1 answer
Mysql add comment to column
SQL
6 votes183 views3 answers
Date_trunc postgres
SQL
3 votes161 views1 answer
Oracle limit user tablespace
SQL
5 votes171 views1 answer
Sysdate in oracle sql
SQL
2 votes164 views1 answer
Sqlite show table indexes
SQL
20 votes190 views3 answers
Update values in select statement sql
SQL
0 vote197 views2 answers
Starts and end with vowel sql
SQL