/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

10 votes250 views1 answer
Oracle view dependencies
SQL
1 vote285 views1 answer
Can not connect to mysql server
SQL
3 votes311 views1 answer
Laravel database Using Named Bindings
SQL
0 vote289 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote306 views1 answer
Mariadb search columns
SQL
0 vote296 views1 answer
Sql contains numeric characters
SQL
0 vote318 views1 answer
Select place default lat long
SQL
3 votes301 views2 answers
Create schema postgres
SQL
0 vote274 views1 answer
Format the money fied with comma in international system using sql
SQL
5 votes286 views1 answer
Oracle scan source ddl
SQL