/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 vote145 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote145 views1 answer
Launch sql script from docker in mysql
SQL
1 vote163 views1 answer
Set statiscis on in ssms
SQL
0 vote164 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
3 votes244 views1 answer
Sql add two values together
SQL
1 vote202 views2 answers
List tables sqlalchemy
SQL
1 vote169 views1 answer
Mysql curdate between two dates
SQL
0 vote261 views1 answer
Mysql select field if condition
SQL
19 votes165 views6 answers
Mysql if null
SQL
-1 vote166 views1 answer
Sql select data from one database and insert into a different database
SQL