/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 vote257 views3 answers
Mysqli count down
SQL
0 vote198 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote276 views1 answer
Create new table from old table with data
SQL
0 vote239 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote358 views1 answer
Import sql file from laravel
SQL
0 vote204 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote242 views1 answer
Mysql show foreign keys column
SQL
0 vote208 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote190 views1 answer
Alter table myisam to innodb
SQL
0 vote212 views1 answer
Load utilities in sql server
SQL