OBJECT_ID临时表无效
1 --存储过程中可以对临时表进行删除,不需要手动选择drop语句即可在每次开始执行存储过程时删除 2 IF OBJECT_ID ('dbo.new_employees_1', 'U') IS NOT NULL 3 DROP TABLE #new_employees_1; 4 GO 5 SELECT * from new_employees 6 7 /*对临时表无效*/ 8 IF OBJECT_ID ('#Table_1', 'U') IS NOT NULL 9 DROP TABLE #Table_1;