/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

1 vote128 views1 answer
Full sql mode
SQL
0 vote108 views1 answer
Incorrect datetime value sql table error 1292
SQL
6 votes117 views3 answers
Oracle all dates between two dates
SQL
0 vote191 views1 answer
Mysql disable triggers
SQL
0 vote115 views1 answer
How to install postgresql on wsl
SQL
0 vote112 views2 answers
Find Overlapping sql
SQL
19 votes126 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote139 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote117 views1 answer
Sql query wordpress export post
SQL
1 vote127 views1 answer
How to unlock table in mysql
SQL