判断临时表是否存在Way 1if(exists(select name from tempdb..sysobjects where name like'%temptab%' and type='U'))drop table #temptabWay 2 if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tempcitys') and type='U')drop table #tempcitysWay 3IF OBJECT_ID('tempdb..#') IS NOT NULLDROP TABLE #OBJECT_ID此函数返回数据库对象标识号...
