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 votes200 views1 answer
How to open database
SQL
2 votes213 views2 answers
Storing timezones in postgres
SQL
0 vote182 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
2 votes327 views1 answer
How to create sql database
SQL
1 vote187 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote197 views1 answer
Oracle sql add column auto generated value
SQL
1 vote186 views3 answers
Remove unique key from a table
SQL
22 votes243 views4 answers
Date format mysql
SQL
0 vote246 views1 answer
Sql get table last modified time
SQL
0 vote179 views1 answer
Sqldf change user
SQL