Sql Server查找临时表,并删除: if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#temp')) drop table #temp http://all.cnblogs.com/archive/2005/11/15/ContactUs.aspx?page=2&paging=1