/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 vote239 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
3 votes239 views2 answers
To_char oracle
SQL
1 vote256 views2 answers
Mysql switch case
SQL
0 vote223 views1 answer
Access refused mysql xampp server
SQL
1 vote244 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote237 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote235 views1 answer
How to create an SQL save method in ruby
SQL
0 vote260 views1 answer
Sql express database size limit
SQL
0 vote232 views1 answer
Sauvegarde complète my sql
SQL
1 vote227 views1 answer
Check message id sql server
SQL