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

2 votes146 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote153 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote140 views1 answer
Acutal month year
SQL
3 votes150 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
-1 vote214 views1 answer
Get month and year from date in mysql sequelize
SQL
1 vote150 views1 answer
Mysql select utc time in eastern time
SQL
3 votes213 views6 answers
Jwt laravel
SQL
4 votes141 views1 answer
Check database name postgresql
SQL
0 vote240 views3 answers
Osx stop mysql service
SQL
6 votes241 views3 answers
Psql show columns of table
SQL