SELECT ID=identity(int,1,1),DefectClasses.ClassId, DefectClasses.ChineseName, DefectSamples.Class,
COUNT(DefectSamples.Class) AS MyCount
into #temp
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)
GROUP BY DefectSamples.Class, DefectClasses.ClassId, DefectClasses.ChineseName
select * from #temp
drop table #temlp
COUNT(DefectSamples.Class) AS MyCount
into #temp
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)
GROUP BY DefectSamples.Class, DefectClasses.ClassId, DefectClasses.ChineseName
select * from #temp
drop table #temlp
解决方案 »
- 插入数据库后用select @@IDENTITY返回id时返回的是一个字符串
- 重开一贴,谢谢大家。顺便再提个问,嘻嘻~!
- 请问ACCESS索引的问题,和具体应用
- 表中数据=两表中的数据相加,请老师指导
- 对不起,没有informix区,只得发在这里,也和sqlserver有些关系
- 这是什么加密
- 安装了SQL2005,到最后的时候提示我:执行安装向导期间出错,有关详细信息,您可以查看安装日志和/或单击帮助按钮。
- 如何找回丢失的数据
- 怎样在数据库的FOR XML查询中获取结果
- 如何按最后回复的帖子的发表时间来对论坛的主题列表排序?
- How to enable the edit option in SQL Query analyzer
- 在存储过程中能用事务吗?
数据库中已存在名为 '#temp' 的对象。
COUNT(DefectSamples.Class) AS MyCount
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)
GROUP BY DefectSamples.Class, DefectClasses.ClassId, DefectClasses.ChineseName
COUNT(DefectSamples.Class) AS MyCount
into #temp5
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)
GROUP BY DefectSamples.Class, DefectClasses.ClassId, DefectClasses.ChineseNameselect * from #temp5
union all
SELECT '合计' as 序号, null as ClassId, null as ChineseName, null as Class,
COUNT(DefectSamples.Class) AS MyCount
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)drop table #temp5请大家看上面的SQL语句错在什么地方?报错信息为:
“服务器: 消息 245,级别 16,状态 1,行 9
将 varchar 值 '合计' 转换为数据类型为 int 的列时发生语法错误。”
SELECT '' , '', '', '合计;',
COUNT(DefectSamples.Class) AS MyCount
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)
但是这样,第一列好想会自动增加一个0
union all
SELECT '合计' as 序号, null as ClassId, null as ChineseName, null as Class,
COUNT(DefectSamples.Class) AS MyCount
FROM DefectSamples INNER JOIN
DefectClasses ON DefectSamples.Class = DefectClasses.ClassId
WHERE (DefectSamples.Verified = 1)