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 vote142 views1 answer
Fetch second word from a string in ms sql
SQL
12 votes148 views2 answers
Delete entries in postgresql
SQL
3 votes168 views3 answers
1396(hy00) mysql error
SQL
0 vote147 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote150 views1 answer
Wp_query raw sql
SQL
0 vote181 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote158 views1 answer
Oracle list partitions
SQL
1 vote157 views1 answer
Psql human readable
SQL
0 vote154 views2 answers
Oracle chain rules
SQL
0 vote178 views1 answer
Get total and distict row diff in sql
SQL