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 vote116 views1 answer
Sql server query database space available
SQL
0 vote122 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote124 views2 answers
Homebrew nysql launch
SQL
0 vote122 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote117 views1 answer
Offset in postgresql example
SQL
0 vote121 views1 answer
MySql Modify Increment
SQL
0 vote119 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes110 views3 answers
Order by value mysql
SQL
14 votes120 views3 answers
Sql trim from string
SQL
2 votes111 views1 answer
Select from array in psql
SQL