/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 vote120 views1 answer
Postgresql datetrunc too slow
SQL
2 votes110 views1 answer
How to check if a row is null in sql
SQL
27 votes122 views6 answers
Sql update record
SQL
0 vote102 views1 answer
Sql character index
SQL
1 vote111 views1 answer
Mysql select utc time in eastern time
SQL
0 vote158 views1 answer
Sql select max value for each group
SQL
2 votes118 views1 answer
Oracle list grants on procedure
SQL
0 vote111 views1 answer
Will graphql replace sql
SQL
2 votes107 views4 answers
Mysql select into new table
SQL
0 vote115 views1 answer
Sql find gaps in date ranges
SQL