各位大侠帮我看看这错哪里了:
create procedure CAL_GPA
@SNO nchar(10),
@GPA float outputas
select @GPA=sum(CREDIT*a)/sum(CREDIT)
from (
(select SNO,CNO,GRADE,CREDIT,(GRADE-60)*0.1+1 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE>=60)
union
(select SNO,CNO,GRADE,CREDIT,0 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE<60 or GRADE is null)
where SNO=@SNO
create procedure CAL_GPA
@SNO nchar(10),
@GPA float outputas
select @GPA=sum(CREDIT*a)/sum(CREDIT)
from (
(select SNO,CNO,GRADE,CREDIT,(GRADE-60)*0.1+1 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE>=60)
union
(select SNO,CNO,GRADE,CREDIT,0 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE<60 or GRADE is null)
where SNO=@SNO
解决方案 »
- 输入带有 html tag 的数据进入 mssql 的database,
- 多表取数问题
- 为什么这句话会报错?
- 請教一個有關排序的問題
- 求救,关于SQL连接问题
- IA_Subsidiary表的数据已达到六百万条记录,运行速度非常慢,请帮忙给一个SQL语句汇总一下里边的数据,谢谢!
- 兄弟们过来瞧瞧,一个select花费13分钟也出不来结果
- 关于"已生成用于更新的结果集 " 问题
- 我的问题难就难在需要有专业有经验(在线打滚哭求高手指教,等于拯救小弟!!!)
- 请大家多提点思路 广域网问题 直接用链接服务器的方法可行吗 用分布式事务可行吗 部分地区用拨号连
- sql比较
- 请问SQL Server 2005用户的读写权限怎么设置?
@SNO nchar(10),
@GPA float output
as
select @GPA = sum(CREDIT*a)/sum(CREDIT)
from
(
select SNO,CNO,GRADE,CREDIT,(GRADE-60)*0.1+1 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE>=60
union
select SNO,CNO,GRADE,CREDIT,0 as a
from SC inner join Courses on SC.CNO=Courses.CNO
where GRADE <60 or GRADE is null
) t
where SNO=@SNO