/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

3 votes275 views3 answers
Into in sql
SQL
0 vote294 views1 answer
Mysql root permission denied lost
SQL
1 vote281 views1 answer
Mysql show long running queries
SQL
0 vote237 views1 answer
Mysqli or pdo
SQL
5 votes307 views1 answer
Oracle nls session
SQL
24 votes290 views4 answers
Postgres remove database
SQL
1 vote283 views2 answers
Drop table if exists test
SQL
0 vote320 views1 answer
Typical max-connect-errors mysql
SQL
1 vote289 views1 answer
Sample clause in sql
SQL
1 vote293 views1 answer
Too many connections mysql
SQL