Temp #Tables是在tempdb中创建的。试试这个：
IF OBJECT_ID('tempdb..#lu_sensor_name_19') IS NOT NULL BEGIN DROP TABLE #lu_sensor_name_19 ENDCREATE TABLE #lu_sensor_name_19...SQL Server 2016增加了在一行中完成删除的功能：
DROP TABLE IF EXISTS #lu_sensor_name_19CREATE TABLE #lu_sensor_name_19...
