/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

2 votes188 views1 answer
Metasploit start postgresql
SQL
1 vote172 views1 answer
Sql myisam vs innodb
SQL
0 vote207 views1 answer
Sql quary stuf
SQL
1 vote212 views1 answer
Pentaho + pasar de excel a sql
SQL
14 votes178 views2 answers
Oracle add column with default value
SQL
0 vote172 views1 answer
Query on date sqlite flutter
SQL
0 vote203 views1 answer
How to see the query of a view in mysql
SQL
1 vote180 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote247 views1 answer
Liquibase update row
SQL
1 vote314 views3 answers
Uninstall postgresql mac
SQL