/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 vote140 views1 answer
Psql list view rules
SQL
0 vote136 views1 answer
Python sql last insertend
SQL
0 vote132 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote174 views3 answers
Mysql CAST(amount as float)
SQL
9 votes139 views4 answers
Postgresql export database
SQL
0 vote136 views1 answer
How to select all fieldsin a soql query
SQL
1 vote179 views1 answer
Pgsql sum switch case
SQL
0 vote126 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote127 views1 answer
Sql random decimal
SQL
7 votes140 views2 answers
Get database size mysql
SQL