/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

9 votes185 views2 answers
Convert data type in sql
SQL
0 vote173 views1 answer
Mysql workbench primary key
SQL
-2 votes182 views1 answer
Mysql see users and passwords
SQL
0 vote170 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote163 views1 answer
Oracle get current schema
SQL
0 vote292 views1 answer
Oracle convert int to date
SQL
0 vote186 views1 answer
Like date sql server not working
SQL
0 vote163 views2 answers
Update all columns in one update
SQL
2 votes191 views1 answer
Sql OR
SQL
0 vote177 views1 answer
Sql sum show 0 result
SQL