/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 vote136 views1 answer
Check index sql server
SQL
8 votes159 views10 answers
Sql
SQL
6 votes139 views4 answers
How to remove unique key in mysql
SQL
0 vote134 views1 answer
Sql trim whitespace
SQL
0 vote136 views1 answer
Max length found in mysql
SQL
5 votes144 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote157 views1 answer
Sub query in linq
SQL
3 votes186 views1 answer
Query less than datetime sql
SQL
0 vote146 views1 answer
Oracle array
SQL
1 vote141 views2 answers
Mysql: command not found
SQL