/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

16 votes190 views4 answers
Mysql import from sql file
SQL
8 votes195 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
6 votes200 views2 answers
Oracle undotbs usage
SQL
0 vote211 views1 answer
For row in sql database python loop
SQL
0 vote187 views1 answer
Pl sql search saurce code
SQL
1 vote196 views1 answer
Psql connections
SQL
15 votes276 views4 answers
Mysql export database command line
SQL
4 votes204 views3 answers
Drop Table Oracle
SQL
0 vote186 views1 answer
Python mysql show databases
SQL
1 vote200 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL