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

2 votes182 views2 answers
Mysql compare datetime to another datetime
SQL
7 votes113 views4 answers
Lowest salary in sql
SQL
0 vote109 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote112 views1 answer
Get yesterday date ISO in psql
SQL
0 vote114 views1 answer
RowDataPacket
SQL
0 vote113 views1 answer
Sql contains numeric characters
SQL
0 vote123 views1 answer
Mysql filter based on datediff
SQL
19 votes120 views6 answers
What is mySQL
SQL
16 votes137 views6 answers
Python sqlite
SQL
2 votes118 views1 answer
Set boolean flasksql
SQL