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 vote175 views1 answer
Change schema of all tables postgres
SQL
0 vote237 views1 answer
Prisma transaction
SQL
0 vote177 views1 answer
Datetime postgres typeorm
SQL
0 vote184 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes221 views1 answer
Mysql cli connect with password
SQL
1 vote182 views1 answer
MySQL AND Operator
SQL
0 vote125 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote254 views1 answer
Restart serial number for postgres
SQL
9 votes201 views1 answer
Alter table column change data type to text mysql
SQL
0 vote176 views1 answer
How to know if table in rigt or left in sql
SQL