/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

10 votes197 views2 answers
Tsql merge example
SQL
-1 vote172 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote187 views1 answer
Stored function in sql
SQL
13 votes169 views2 answers
Display users in mysql
SQL
2 votes187 views2 answers
Postgresql search all tables for column name
SQL
1 vote193 views1 answer
Sql string function update replace
SQL
16 votes188 views2 answers
Sql exists
SQL
1 vote185 views1 answer
Oracle stop job
SQL
2 votes181 views1 answer
Get hour from date sql
SQL
0 vote177 views1 answer
Luu ckeditor vao mysql
SQL