/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 vote150 views2 answers
Android sqlite query join
SQL
1 vote191 views2 answers
Find nth highest salary of an employee
SQL
9 votes166 views1 answer
Sql server get utc date
SQL
1 vote203 views1 answer
Sql order by timestamp
SQL
10 votes176 views4 answers
Primary key sql
SQL
2 votes212 views6 answers
In operator in sql
SQL
0 vote186 views2 answers
List all constraints in postgres
SQL
92 votes2.3K views6 answers
Substring
SQL
3 votes229 views2 answers
How to open postgresql in windows
SQL
0 vote174 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL