/SQL/Sql server check if temp table exists

Sql server check if temp table exists

Sql server drop temp table if exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

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 vote141 views1 answer
Clear screen command in psql
SQL
1 vote137 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote132 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote107 views1 answer
Create duplicate table postgres
SQL
9 votes147 views3 answers
Mysql run sql file
SQL
0 vote144 views1 answer
Mysql multiple group by
SQL
2 votes149 views1 answer
Mysql change data type of column
SQL
0 vote273 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
12 votes143 views4 answers
Mysql version query
SQL
1 vote239 views1 answer
How to select department from table
SQL