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

1 vote140 views1 answer
Where database run
SQL
1 vote132 views1 answer
Mysqli connect
SQL
0 vote127 views1 answer
Mysql update sequence with order by
SQL
3 votes134 views1 answer
Oracle sleep
SQL
-1 vote137 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote165 views1 answer
Delet all record statment sql
SQL
4 votes134 views3 answers
Mysql update with join
SQL
1 vote139 views1 answer
Postgres concat_ws
SQL
1 vote155 views1 answer
Sql group by sum with condition
SQL
-1 vote157 views1 answer
Mysql coalesce
SQL