IF EXISTS(select * from tempdb..sysobjects where id=object_id(‘tempdb..#tb‘)) BEGIN DROP TABLE #tb END
SQL判断临时表是否存在,布布扣,bubuko.com
SQL判断临时表是否存在
原文:http://www.cnblogs.com/allen0118/p/3872966.html