/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

3 votes309 views2 answers
Oracle grants
SQL
0 vote320 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote293 views1 answer
Sql getdate date only
SQL
0 vote309 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote338 views1 answer
Date 3 months from today sql
SQL
17 votes325 views4 answers
Mysql remove ubuntu
SQL
0 vote346 views1 answer
Stored procedure function relation
SQL
0 vote342 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote340 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote299 views2 answers
Python mysql create table if not exists
SQL