/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 vote106 views1 answer
Generate sequence number in sql server
SQL
17 votes121 views5 answers
Order by sql
SQL
0 vote99 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote110 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote95 views1 answer
Clone table structure mysql
SQL
1 vote101 views1 answer
Last 6 months postgresql
SQL
0 vote130 views1 answer
Sql date time query find
SQL
1 vote107 views2 answers
Backup table mssql
SQL
0 vote116 views1 answer
Mysql order by where condition sub query
SQL
0 vote101 views1 answer
Downgrading sql localdb visual studio
SQL