查询当前临时表 :select name from tempdb.dbo.sysobjects where type='u' and name like '#%'
查询表名是否存在:IF EXISTS (select * from tempdb.dbo.sysobjects where name like '%'+@tableform+'%' and type='U')
查询表名是否存在:IF EXISTS (select * from tempdb.dbo.sysobjects where name like '%'+@tableform+'%' and type='U')