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 vote179 views1 answer
Select statement to print longest name
SQL
14 votes223 views2 answers
Sql cast
SQL
2 votes261 views1 answer
Brew start postgres manual
SQL
3 votes189 views1 answer
Show index table
SQL
1 vote218 views1 answer
Ubuntu access database from terminal
SQL
0 vote186 views1 answer
Sql add calculated column
SQL
2 votes286 views1 answer
Oracle run_duration to number
SQL
0 vote198 views1 answer
Oracle running queries sql
SQL
0 vote227 views1 answer
Display all node label neo4j
SQL
0 vote220 views1 answer
Min varias colunas spark sql
SQL