Check if sql temp table exists

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 vote190 views1 answer
Insert value in identity
SQL
0 vote120 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote183 views1 answer
Sql combine results from two tables
SQL
0 vote166 views1 answer
Alter table myisam to innodb
SQL
1 vote162 views2 answers
String to date postgres
SQL
1 vote165 views1 answer
Sql where last 12 months
SQL
0 vote188 views1 answer
Test sql query
SQL
0 vote198 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote160 views1 answer
Restart sql server command line linux
SQL
0 vote155 views1 answer
If exist column in table drop sql query mysql
SQL