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 vote108 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
3 votes105 views2 answers
Truncate all tables
SQL
0 vote110 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
4 votes139 views2 answers
Postgresql float data type
SQL
0 vote112 views1 answer
Sql server separar numeros por comas miles
SQL
4 votes113 views3 answers
Sql drop primary key
SQL
2 votes122 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote118 views1 answer
Insert or update sql firebird
SQL
0 vote103 views1 answer
Désinstaller postgresql linux
SQL
3 votes110 views1 answer
Create a table with an id in mysql
SQL