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 vote322 views1 answer
Sqlite woth cmake
SQL
1 vote302 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote297 views2 answers
How to use aggregate functions in sql
SQL
6 votes306 views2 answers
Psql load dump
SQL
0 vote297 views2 answers
Enter into postgresql database,create user and grant Access
SQL
25 votes318 views4 answers
Sqlserver add column
SQL
0 vote292 views1 answer
Mysql utc timestamp
SQL
1 vote285 views1 answer
Neo4j display all nodes and relationships
SQL
6 votes313 views2 answers
Mysqldump password in file
SQL
1 vote237 views1 answer
Prevent duplicate rows in postgres
SQL