--第一种方式 create table #tmp(name varchar(255),id int)--第二种方式select count(id) as storyNum ,sum(convert(numeric(10,2),case when isnumeric(code)=1 then code else 0 end)) as codeNum,sum((case when isnumeric(realcode)=1 then convert(numeric(10,2),realcode) else 0.0 end)) as realcodeNum,tdtname,cycle,jiracomponent,jirastatename,qualityvalue,storycodellt into #tmp from IKNOW_STORY_U2000V1R7C00 group by tdtname,cycle,jiracomponent,jirastatename,qualityvalue,storycodellt--查询临时表select * from #tmp--删除临时表if object_id(‘tempdb..#tmp‘) is not null begin drop table #tmp end
sql 判断临时表是否存在，删除临时表重建
--正确的临时表删除操作if object_id(‘tempdb..#tempTable‘) is not null Begin drop table #tempTableEnd
原文：https://www.cnblogs.com/skyay/p/12558316.html