/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 vote205 views2 answers
Mysql extract month
SQL
1 vote200 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote200 views1 answer
Add created and updatedAt fields in mysql
SQL
1 vote219 views1 answer
Sql set auto increment back to 0
SQL
1 vote213 views1 answer
How to unlock table in mysql
SQL
4 votes193 views2 answers
Postgresql reset sequence
SQL
0 vote225 views1 answer
Mysql persistence.xml
SQL
4 votes219 views2 answers
Float postgres
SQL
0 vote213 views1 answer
Get primary key of table
SQL
3 votes229 views1 answer
DB: in eloquent using sql
SQL