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 vote357 views1 answer
Postgres foreign key multiple columns
SQL
0 vote322 views1 answer
Mysql group by range
SQL
6 votes313 views1 answer
Allsource oracle
SQL
2 votes324 views1 answer
Set boolean flasksql
SQL
2 votes367 views1 answer
Python sql
SQL
0 vote334 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote307 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote343 views1 answer
Shortcut run sql pgadmin
SQL
7 votes310 views2 answers
N highest salary in sql
SQL
0 vote326 views1 answer
Calculate date and convert to yearsmysql
SQL