/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 vote140 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote136 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote243 views1 answer
Install mysql on bash
SQL
4 votes116 views4 answers
What is primary key
SQL
0 vote162 views1 answer
Migrations.RunSQL
SQL
0 vote130 views1 answer
How to find database collation in postgres
SQL
37 votes128 views3 answers
Duplicate records in sql
SQL
4 votes120 views1 answer
Sql delete where in select
SQL
4 votes149 views1 answer
Is there any command to change postgres password
SQL
15 votes255 views2 answers
Sql order by alphabetical
SQL