/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 vote332 views1 answer
Implicit inner join table alias with id values
SQL
2 votes368 views2 answers
Mysql alter column default
SQL
0 vote392 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote335 views2 answers
Mysql current user
SQL
1 vote351 views1 answer
How to delete data from sql database in android
SQL
0 vote347 views1 answer
Get foreign table names mysql
SQL
14 votes361 views1 answer
Oracle alter table add column not null
SQL
0 vote431 views1 answer
Mysql get longest string in column
SQL
0 vote371 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
-1 vote360 views1 answer
Condition in orderby mysql
SQL