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 votes252 views2 answers
Insert all in sql
SQL
3 votes291 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
27 votes272 views4 answers
Get all tables with column name sql
SQL
-2 votes284 views2 answers
Union vs union all in sql
SQL
1 vote276 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote247 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
2 votes262 views2 answers
Set database timezone mysql
SQL
0 vote281 views1 answer
Can you write relational algebra into sql queries
SQL
17 votes279 views6 answers
Current date in sql
SQL
1 vote255 views1 answer
Import database from a file using mysql commandline
SQL