/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

0 vote157 views2 answers
Avg() sql
SQL
0 vote242 views1 answer
Postgresql import data from csv
SQL
0 vote223 views1 answer
Select top values sql
SQL
8 votes175 views1 answer
Oracle current date plus 1 month
SQL
0 vote195 views1 answer
Create database store
SQL
0 vote203 views1 answer
Mysql, how to query the table comments?
SQL
12 votes220 views1 answer
Create column sql server
SQL
0 vote182 views1 answer
Alter table fulltext
SQL
22 votes179 views2 answers
Mysql show all tables
SQL
0 vote197 views2 answers
Connect to mysql server mac terminal
SQL