/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 vote348 views1 answer
SQL query to verify the size of the table
SQL
4 votes323 views1 answer
Adding data to table in sql python
SQL
-1 vote316 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
14 votes358 views3 answers
How to add default constraint in mysql
SQL
1 vote330 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote312 views1 answer
Including parameters in OPENQUERY
SQL
0 vote345 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
12 votes323 views1 answer
Docker run mysql image
SQL
0 vote334 views1 answer
How to move a column to different spot mysql
SQL
5 votes324 views3 answers
Day of week postgresql
SQL