/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 vote368 views1 answer
Sql server size of every table in a db
SQL
2 votes363 views1 answer
Change primary key sql
SQL
0 vote450 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote370 views1 answer
Select all columns except one sql
SQL
19 votes367 views4 answers
Rename database in sql
SQL
0 vote419 views1 answer
Sql show founctions
SQL
0 vote390 views1 answer
C# sql transaction multiple connections
SQL
0 vote331 views1 answer
Mysql sleep connections
SQL
0 vote370 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
3 votes341 views1 answer
Delete all content in table mysql
SQL