/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

6 votes203 views1 answer
Wordpress change user password sql
SQL
2 votes194 views1 answer
Oracle create directory
SQL
0 vote237 views1 answer
Compress sql file database ubuntu
SQL
2 votes197 views1 answer
SQL column name Postgre
SQL
0 vote216 views1 answer
Restart sql server command line linux
SQL
2 votes206 views1 answer
Oracle kill session by sql_id
SQL
0 vote206 views2 answers
Close external port 3306 with iptables
SQL
0 vote178 views2 answers
Spring properties file for db
SQL
0 vote210 views1 answer
Returning with sqlalchemy
SQL
0 vote239 views1 answer
Traccar mysql
SQL