/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 vote271 views1 answer
Drop-toys-table
SQL
12 votes242 views1 answer
Create column sql server
SQL
0 vote255 views1 answer
View to table
SQL
0 vote292 views1 answer
Mysql get nth highest
SQL
0 vote271 views1 answer
Stored procedures example
SQL
0 vote257 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote263 views1 answer
Mysql decimal allow negative values?
SQL
0 vote290 views1 answer
How to find date from date table in sql
SQL
1 vote270 views1 answer
Quit mysql
SQL
0 vote234 views1 answer
Automate mysql cli query
SQL