use stuDB
declare @sumscore int
select @sumscore=sum(labExam) FROM stuMarks
print '机试总成绩为:'+convert(varchar(5),@sumscore)
declare @n int
while (1=1)
begin
select @n=COUNT(*)FROM stuMarks where labExam<60
if (@n>0)
update stuMarks set labExam=labExam+2
else
break
end
print '加分后的成绩如下:'
select *from stuMarks1:加分后成绩>100 按100 显示, PS: 就这个小问题,表不给你们了,我想要语法,谢谢大家。
declare @sumscore int
select @sumscore=sum(labExam) FROM stuMarks
print '机试总成绩为:'+convert(varchar(5),@sumscore)
declare @n int
select @n=COUNT(*)FROM stuMarks where labExam <60
if (@n>0)
begin
update stuMarks set labExam=labExam+2
end
print '加分后的成绩如下:'
select CASE WHEN labExam> 100 THEN 100 ELSE labexam end as labexam from stuMarks 给所有的加2分是吗?