Sql

Search

sql server check if temp table exists

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results

Comment

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: psql change table schema
Sql :: mysql install with docker
Sql :: find duplicates mysql
Sql :: how to add where command in update comand with joins
Sql :: postgres populate table from another table
Sql :: insert query return id mysql
Sql :: mssql disable foreign key constraint
Sql :: postgresql to_char time
Sql :: install mysql workbench ubuntu 20.04
Sql :: show slave status mysql
Sql :: change column name sql server management studio
Sql :: postgres datetime now
Sql :: select distinct
Sql :: c# sql select
Sql :: sql merge
Sql :: Assign value to var in SQL
Sql :: @sqlresultsetmapping
Sql :: cannot drop database because it is currently in use
Sql :: sql server locks
Sql :: mysql change password
Sql :: mysql generate uuid
Sql :: mysql clear screen
Sql :: mysqldump ignore table
Sql :: database dump mysql command
Sql :: mysql full outer join
Sql :: python postgresQL select table
Sql :: foreign key constraint in ms sql
Sql :: mysql update from select on same table
Sql :: linq join
Sql :: nullif postgresql

Search

SQL

sql server check if temp table exists

check if sql temp table exists

ADD CONTENT