例如这里判断临时表#odpcomplete是否存在,存在则删除,方法如下:
IF EXISTS ( SELECT * FROM tempdb.dbo.sysobjects WHERE id = OBJECT_ID(N'tempdb..#odpcomplete') AND type = 'U' ) DROP TABLE #odpcomplete