/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 vote254 views1 answer
Sql myisam vs innodb
SQL
0 vote270 views1 answer
How to install mysql without admin rights
SQL
0 vote270 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote268 views4 answers
Between vs in sql
SQL
16 votes285 views2 answers
Add column if not exists mysql
SQL
0 vote277 views1 answer
Cast for print sql
SQL
0 vote284 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
7 votes290 views2 answers
Create index mysql cli
SQL
3 votes282 views1 answer
Oracle failed login attempts
SQL
0 vote270 views1 answer
Find all tables where column name exists oracle
SQL