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

5 votes245 views2 answers
Sql constraint check value in list
SQL
7 votes247 views1 answer
Oracle pagination query rownum
SQL
0 vote235 views2 answers
Search stored procedures by name
SQL
0 vote237 views1 answer
OFFSET consulta mysql
SQL
0 vote217 views1 answer
Get time component of datetime sql
SQL
1 vote233 views2 answers
Regex starts with
SQL
2 votes233 views1 answer
Mariadb json select
SQL
0 vote187 views1 answer
<script>alert
SQL
0 vote181 views1 answer
Mysql select top 2
SQL
0 vote282 views1 answer
What is metadata in sql
SQL