使用动态SQL执行语句:
exec('select sum(ExamScore)as sumScore,SystemID from [EXAMSCORE] where Course_id in (' + @CourseIDString + ') group by SystemID order by SystemID')
exec('select sum(ExamScore)as sumScore,SystemID from [EXAMSCORE] where Course_id in (' + @CourseIDString + ') group by SystemID order by SystemID')
解决方案 »
- 500多万的数据库优化
- SQL查询中的问题
- 如何设计票据系统数据库结构?
- 请问如何用SQL语句把图片中的形式写出来?
- MS SQL SERVER2000如和利用公式或触发器使该字段的数据是另一表某字段的数据
- 为实现树型表达风格的准备数据。300 分,决不食言!
- 请教:对于对涉及到交易的历史记录数据的处理?
- 狂郁闷,好不容易做了个东西现在高兴不起来了,大家说说怎么办阿!
- SQLStale '01000',错误 11001 和 SQLStale '08001',错误 6 ,是哪里有问题?
- 请问在sql块中GO的具体意思是什么?>
- 字典排序和二进制排序有什么不同,那个比较好呢??(放100分)
- 如何加自增的字段?
你可以用字符串两边加"," 再在“,@InputTestCourseIDString,”内找
“,Course_id,”
如:
declare @InputTestCourseIDString varchar(500)
set @InputTestCourseIDString='1,4,5,10,14,15,16'
set @InputTestCourseIDString=','+@InputTestCourseIDString+','
--@InputTestCourseIDString=,1,4,5,10,14,15,16,select sum(ExamScore)as sumScore,SystemID from [EXAMSCORE] where charindex(','+rtrim(ltrim(Course_id))+',',(@InputTestCourseIDString))>0 group by SystemID order by SystemID
你可以用字符串两边加"," 再在“,@InputTestCourseIDString,”内找
“,Course_id,”
如:
declare @InputTestCourseIDString varchar(500)
set @InputTestCourseIDString='1,4,5,10,14,15,16'
set @InputTestCourseIDString=','+@InputTestCourseIDString+','
--@InputTestCourseIDString=,1,4,5,10,14,15,16,select sum(ExamScore)as sumScore,SystemID from [EXAMSCORE] where charindex(','+rtrim(ltrim(Course_id))+',',(@InputTestCourseIDString))>0 group by SystemID order by SystemID