1、在生成临时表之后,确认是否已经删除
--Method 1
DECLARE @exists int
SELECT @exists = 1 FROM INFORMATION_SCHEMA.tables WHERE table_name ='asdfadf';
SELECT @exists
--Method 2
IF EXISTS(SELECT * FROM sysobjects WHERE id=object_id('tablename') AND OBJECTPROPERTY(id,'IsUserTable') = 1)
begin
drop table tablename
end