/SQL/Sql server check if temp table exists

Sql server check if temp table exists

Sql server drop temp table if exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

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 votes229 views2 answers
Install postgresql
SQL
15 votes211 views2 answers
Sql order by multiple columns
SQL
1 vote201 views1 answer
Group_concat order by
SQL
0 vote249 views1 answer
Sql quary stuf
SQL
0 vote253 views1 answer
Original Query
SQL
2 votes287 views1 answer
Brew start postgres manual
SQL
1 vote152 views1 answer
Postgres division by zero
SQL
24 votes197 views6 answers
Rename a column in sql server
SQL
2 votes199 views1 answer
Install sqlite npm
SQL
1 vote219 views2 answers
Begin transaction sql
SQL