/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 votes358 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote364 views2 answers
Postgres having
SQL
11 votes360 views2 answers
Mysql set safe mode off
SQL
1 vote346 views1 answer
Calculate age in sql postgresql
SQL
2 votes361 views1 answer
Add new column not null sql server
SQL
5 votes346 views1 answer
Mysql get last day of month
SQL
0 vote360 views1 answer
Mysql c commands
SQL
0 vote363 views1 answer
Plpgsql raise notice
SQL
0 vote381 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes410 views3 answers
How to replace null values in sql
SQL