/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 vote262 views1 answer
Default value false mysql
SQL
1 vote287 views1 answer
Postgresql round double precision
SQL
0 vote249 views1 answer
Month mysql
SQL
0 vote287 views1 answer
How to add session data into mysql database from button
SQL
2 votes277 views1 answer
Postgresql left join distinct on
SQL
1 vote275 views1 answer
Increase existing date in sql oracle
SQL
10 votes300 views5 answers
Create table mysql query
SQL
0 vote282 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote264 views1 answer
Trigger in postgresql to change incoming entry
SQL
25 votes279 views6 answers
Change column name mysql
SQL