Answers for "how to check if temp table exist in delete"

SQL
0

Check if a temporary table exists and delete if it exists

DROP TABLE IF EXISTS #lu_sensor_name_19 

CREATE TABLE #lu_sensor_name_19...
Posted by: Guest on August-11-2020
0

Check if a temporary table exists and delete if it exists

IF OBJECT_ID('tempdb..#lu_sensor_name_19') IS NOT NULL 
BEGIN 
    DROP TABLE #lu_sensor_name_19 
END

CREATE TABLE #lu_sensor_name_19...
Posted by: Guest on August-11-2020

Code answers related to "how to check if temp table exist in delete"

Code answers related to "SQL"

Browse Popular Code Answers by Language