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 vote175 views1 answer
Deleting database in sql
SQL
3 votes165 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote176 views2 answers
Sql if empty then
SQL
4 votes173 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
14 votes189 views2 answers
Install mysqldump
SQL
0 vote168 views1 answer
Mysql start of today
SQL
0 vote183 views1 answer
Oracle service name view
SQL
3 votes304 views6 answers
Sql unique select
SQL
0 vote193 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote193 views1 answer
Apt install sql server
SQL