如何用sql server 2005创建一个用户自定义函数,以学号和课程名称为参数,返回该学生指定课程的学习成绩
惠铭广告—乐全
2024-09-29 06:48:21
最佳回答
create function func_getscore( @sno nvarchar(20), @coursename nvarchar(50) ) returns decimal(18,2) as begin declare @score decimal(18,2) select @score=score from tbl_sc as t1 inner join tbl_course as t2 on t1.cno=t2.cno where t1.sno=@sno and t2.name=@coursename return @score end tbl_sc(sno,cno,score)为选课表 tbl_course(cno,name,....)为课程表麻烦采纳,谢谢! 20210311