/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 vote137 views1 answer
Postgres sql alter table delete row
SQL
0 vote129 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote143 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote129 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote136 views1 answer
Set mysql socket file docker windows
SQL
3 votes130 views4 answers
Stop MySQL
SQL
2 votes151 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote126 views1 answer
Postgresql isnull with max
SQL
1 vote121 views1 answer
Set id count mysql
SQL
6 votes131 views2 answers
Mysql convert timestamp to date
SQL