/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 vote123 views1 answer
Opensuse status MySQL
SQL
9 votes127 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote135 views1 answer
Oracle allow space to user
SQL
22 votes115 views2 answers
Mysql show all tables
SQL
0 vote150 views1 answer
Sqlite unique multiple columns
SQL
11 votes129 views2 answers
Docker create postgres db
SQL
3 votes258 views6 answers
Sql unique select
SQL
0 vote143 views1 answer
Unique element in sql
SQL
0 vote125 views2 answers
Start mysql server using docker
SQL
0 vote164 views1 answer
Sql count matching group by
SQL