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 vote367 views1 answer
Virtuoso sql query tutorial
SQL
7 votes322 views3 answers
How ot change name of column mysql
SQL
2 votes324 views1 answer
Query any digits record
SQL
2 votes276 views1 answer
Sql select in list
SQL
11 votes294 views2 answers
Having keyword sql
SQL
5 votes297 views1 answer
Oracle ora-00054 causes
SQL
0 vote268 views2 answers
Delete the last item in a table sql
SQL
4 votes377 views4 answers
Check constraint in ms sql
SQL
2 votes308 views1 answer
Sql server conection string
SQL
4 votes315 views3 answers
Order by value mysql
SQL