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 vote171 views1 answer
Sql sum if
SQL
-1 vote203 views1 answer
Mysql faster insert
SQL
0 vote171 views1 answer
Mysql drop multiple tables at once
SQL
1 vote148 views1 answer
Mysql see column types
SQL
3 votes151 views1 answer
Oracle failed login attempts
SQL
0 vote183 views1 answer
How to add more columns to a table in mysql
SQL
0 vote182 views1 answer
SqlFunction does not exist
SQL
0 vote179 views1 answer
Sqlite insert or update
SQL
0 vote244 views1 answer
Last date for each user sql
SQL
12 votes176 views1 answer
Docker mysql random root password
SQL