Check if sql temp table exists

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 vote274 views1 answer
Mysql cli output to a file
SQL
0 vote287 views1 answer
Sql query wordpress export post
SQL
0 vote269 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote253 views1 answer
Drop all tables db2
SQL
1 vote268 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote240 views1 answer
How to delete record sql delphi
SQL
0 vote215 views1 answer
Plsql trigger insert update
SQL
0 vote274 views1 answer
Mysql Install Ubuntu with native password
SQL
103 votes435 views1 answer
Like sql
SQL
5 votes276 views2 answers
Mysql dump mysql db cli
SQL