Question

如何用sql server 2005创建一个用户自定义函数，以学号和课程名称为参数，返回该学生指定课程的学习成绩

Answer 1

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,....)为课程表

麻烦采纳，谢谢!