/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

1 vote291 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote305 views1 answer
Install mysql on bash
SQL
0 vote277 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote275 views2 answers
Mysql dump structure only
SQL
0 vote250 views2 answers
Select limit ms sql
SQL
0 vote253 views1 answer
Create table if not exist with exceptions
SQL
0 vote255 views1 answer
How to access to mysql without root
SQL
1 vote272 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote254 views1 answer
Comma seperated join mssql
SQL
16 votes293 views3 answers
Get count of duplicate records
SQL