-- 1.产生临时表 select * into #tb1 from tb -- 2.查找该临时表是否存在 select * from tempdb..sysobjects where id=object_id('tempdb..#tb1') 转载于:https://www.cnblogs.com/gis_gps/archive/2008/10/20/1315004.html