Answers for "tsql create temp table if not exists"

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,
    )

Posted by: Guest on May-19-2021

Code answers related to "tsql create temp table if not exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "tsql create temp table if not exists"

Code answers related to "tsql create temp table if not exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "tsql create temp table if not exists"

Code answers related to "tsql create temp table if not exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us