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 vote125 views1 answer
Mysql multiple group by
SQL
0 vote123 views1 answer
Sql constarint
SQL
0 vote140 views1 answer
How to check which table has data in mysql
SQL
0 vote132 views1 answer
Psotgres multiple values
SQL
0 vote130 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
2 votes121 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
2 votes128 views1 answer
Set column to not null mysql
SQL
0 vote128 views1 answer
Phpmyadmin tabellentyp ändern
SQL
18 votes155 views2 answers
Sql comments
SQL
0 vote121 views2 answers
Nosqlbooster query other collection
SQL