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 vote195 views1 answer
Mysql add to number
SQL
16 votes187 views1 answer
Mysql reset auto increment value
SQL
3 votes186 views4 answers
Show sql server database
SQL
17 votes191 views3 answers
Cast in sql server
SQL
8 votes191 views3 answers
Postgres connection string
SQL
0 vote248 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote208 views1 answer
Sql delete dastabase
SQL
1 vote184 views1 answer
Mysql check table exists
SQL
5 votes239 views3 answers
Sql server utc to local
SQL
0 vote190 views1 answer
Import big data to mysql
SQL