/SQL/Sql server check if temp table exists

Sql server check if temp table exists

Sql server drop temp table if exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

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 vote326 views1 answer
Horizontal join sqlite
SQL
0 vote340 views1 answer
Mysql extract day from date leading zero
SQL
5 votes379 views1 answer
Oracle get ddl
SQL
19 votes324 views2 answers
Mysql tinyint max value
SQL
0 vote338 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
-1 vote323 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote311 views1 answer
Sql delete all values in a column
SQL
3 votes345 views1 answer
Two select sql
SQL
0 vote327 views1 answer
Mysql multiple count
SQL
3 votes324 views2 answers
To_char oracle
SQL