/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 vote156 views1 answer
Ms sql filter all sympbol
SQL
4 votes177 views3 answers
Mysql get column names from table
SQL
3 votes143 views2 answers
Postgresql remove not null constraint
SQL
0 vote252 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
22 votes152 views4 answers
Mysql date_format
SQL
0 vote252 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote141 views1 answer
Sql convert datetime to year
SQL
0 vote141 views1 answer
Sql show all users
SQL
21 votes144 views1 answer
SQL cheat sheet pdf
SQL
3 votes152 views1 answer
Sql server check version
SQL