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

2 votes198 views1 answer
How to search table name in stored procedure in sql server
SQL
17 votes205 views4 answers
Postgres list users
SQL
0 vote204 views1 answer
Casterar postgres
SQL
0 vote187 views1 answer
Psql check if value in array
SQL
0 vote240 views1 answer
What is initial catalog in sql connection string
SQL
0 vote239 views1 answer
Joomla execute raw sql
SQL
0 vote189 views1 answer
Database springboot
SQL
1 vote240 views2 answers
Sql select only row with the max date
SQL
0 vote242 views1 answer
Sql describe
SQL
5 votes200 views6 answers
In operator sql
SQL