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 vote251 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote273 views1 answer
Sql shell psql cannot enter password
SQL
0 vote270 views1 answer
Oracle array
SQL
1 vote276 views1 answer
Too many connections mysql
SQL
0 vote283 views1 answer
Proc sql not in working
SQL
0 vote272 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote257 views1 answer
Luu ckeditor vao mysql
SQL
0 vote283 views2 answers
Call to undefined function mysql_query()
SQL
0 vote298 views1 answer
Sql cursor example multiple columns
SQL
-1 vote255 views1 answer
Io
SQL