/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

0 vote325 views1 answer
Jooq replace
SQL
0 vote314 views0 answer
SQL
0 vote400 views1 answer
Remove mysql from centos 7
SQL
13 votes344 views2 answers
Sqlite rename table
SQL
0 vote336 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote325 views1 answer
Convert sql server guid to varbinary
SQL
0 vote361 views1 answer
Data directory postgresql
SQL
0 vote381 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote542 views1 answer
Multiple row join
SQL
1 vote350 views2 answers
Get table column names sql laravel
SQL