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

4 votes315 views1 answer
Datepart postgres
SQL
0 vote330 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote325 views1 answer
Rename constraint postgresql
SQL
0 vote301 views2 answers
Postgresql display subquery as json
SQL
3 votes301 views1 answer
Postgres update column with value from another table
SQL
2 votes321 views1 answer
Mysql select default if null
SQL
0 vote297 views1 answer
Postgre admin slow
SQL
1 vote290 views1 answer
Input in mysql
SQL
11 votes279 views1 answer
Reset identity sql server
SQL
0 vote380 views1 answer
Mysql get longest string in column
SQL