/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 vote145 views1 answer
Wherein mysql
SQL
5 votes176 views1 answer
How to get all table names in sql query
SQL
6 votes140 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
6 votes159 views1 answer
SQL insert all columns
SQL
6 votes162 views1 answer
Allsource oracle
SQL
1 vote240 views1 answer
Primary key reset in SQL database
SQL
1 vote279 views1 answer
Import sql file from laravel
SQL
3 votes160 views1 answer
Insert into table from another table mysql
SQL
10 votes163 views1 answer
Oracle dependencies table
SQL
0 vote160 views1 answer
Mysql update set sum
SQL