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 vote203 views1 answer
Get all employees if name ends with in sql
SQL
0 vote224 views1 answer
Psql attribute cannot login
SQL
0 vote238 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote201 views1 answer
Select from 3 tables one is empty
SQL
0 vote209 views1 answer
Drop specific row postgresql
SQL
7 votes216 views2 answers
Oracle foreign key reference table
SQL
6 votes216 views5 answers
Mysql get last insert id
SQL
0 vote219 views2 answers
SQL BULK INSERT
SQL
0 vote212 views1 answer
Update table sql multiple set
SQL
2 votes218 views1 answer
Mariadb JSON_EXTRACT
SQL