/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 votes342 views1 answer
How to select from mssql
SQL
10 votes327 views3 answers
Join multiple tables sql
SQL
0 vote289 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
1 vote348 views1 answer
Sql view where tables have same column name combine results
SQL
16 votes317 views2 answers
Add column to all tables after first column mysql
SQL
1 vote327 views1 answer
Mysql not supported auth mode
SQL
5 votes330 views1 answer
Invalid column name sql
SQL
0 vote309 views2 answers
SQL Server Standard
SQL
0 vote355 views1 answer
Combine 2 columns search query mysql
SQL
3 votes310 views1 answer
Select table column in sql
SQL