/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 vote193 views1 answer
Oracle rolling back transactions
SQL
0 vote191 views1 answer
Count the table indatabase
SQL
1 vote182 views1 answer
Mysql remove last empty newline
SQL
3 votes184 views1 answer
Oracle nextval
SQL
24 votes210 views6 answers
Alter table name sql
SQL
16 votes194 views6 answers
Mysql find and replace
SQL
0 vote210 views1 answer
Migration graphql
SQL
1 vote195 views1 answer
Postgres set column based on another column
SQL
5 votes187 views2 answers
Oracle tables with column name
SQL
0 vote191 views1 answer
Pip install mysqlclient error
SQL