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

1 vote145 views1 answer
Sql server kill all connections
SQL
0 vote148 views1 answer
Oracle execute immediate quotes
SQL
0 vote132 views1 answer
Postgresql on conflict pair
SQL
0 vote135 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote130 views1 answer
Sqlite explain plan
SQL
0 vote134 views1 answer
How to to get current date in sql
SQL
-1 vote88 views1 answer
Oracle db list usernames
SQL
0 vote135 views1 answer
Criteria builder select subset of column
SQL
6 votes144 views4 answers
Mysql group by month
SQL
0 vote140 views1 answer
View psql output in horizontal scrolling
SQL