Check if sql temp table exists

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 vote363 views1 answer
Check user sql password from command line
SQL
0 vote283 views1 answer
Online sql compiler
SQL
0 vote352 views1 answer
T sql dynamic top n query
SQL
0 vote320 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
2 votes348 views1 answer
Scaffold npgsql net core
SQL
1 vote333 views1 answer
Get last week data in mysql
SQL
0 vote364 views1 answer
Oracle sql alter view add column
SQL
0 vote347 views2 answers
Advantages of stored procedures sql
SQL
2 votes375 views2 answers
Mysql does sentence contain word
SQL
8 votes352 views1 answer
Today minus 15 days postgresql
SQL