/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 vote208 views1 answer
Sql drop default
SQL
0 vote210 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote213 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote179 views1 answer
Mysqli or pdo
SQL
0 vote201 views1 answer
Describe in sqlite3
SQL
1 vote213 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote221 views1 answer
Odd record sql query
SQL
0 vote206 views1 answer
Double in sql server example
SQL
1 vote217 views2 answers
Mysql trim spaces
SQL
2 votes225 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL