/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

6 votes241 views6 answers
Rename column postgres
SQL
1 vote199 views1 answer
Declare variables sql
SQL
0 vote202 views2 answers
How to generate a unique random number in mysql
SQL
1 vote203 views1 answer
Clear screen command in psql
SQL
0 vote189 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote192 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote197 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote191 views1 answer
Oarcale list objects
SQL
0 vote199 views2 answers
Start mysql server using docker
SQL
0 vote272 views1 answer
Opensuse start MySQL
SQL