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 vote209 views1 answer
Copy data from one postgres container to another
SQL
0 vote185 views1 answer
Heavy table in mysql
SQL
8 votes217 views3 answers
SQL column name
SQL
0 vote231 views2 answers
Insert data mysql with cmd
SQL
1 vote199 views1 answer
Mariadb alter user host
SQL
1 vote201 views4 answers
Psql check tables command
SQL
31 votes198 views3 answers
Sql count
SQL
0 vote234 views2 answers
Greater than sql server
SQL
0 vote199 views1 answer
Composit key in sql
SQL
8 votes222 views1 answer
Oracle search stored procedures for text
SQL