8-6.sql

来自「SQL2000跟课件学习的源代码 分享共同学习」· SQL 代码 · 共 11 行

ALTER PROC spStuGrade_Class_term 	/* 存储过程名 */
  @Para_Term tinyint=1			/* 学期，输入参数，默认值为1 */
AS
  SELECT S.ClassID, S.StudentID, S.StudentName, C.CourseName, G.Grade 
  FROM Grade G INNER JOIN Student S			/* 按StudentID连接Student */
  ON G.StudentID = S.StudentID INNER JOIN Course C  /* 按CourseID连接Course */
  ON G.CourseID = C.CourseID INNER JOIN Speciality_Course SC
  ON G.CourseID = SC.CourseID			/* 按CourseID连接Speciality_Course */
  WHERE SC.Term=@Para_Term			/* 查询的学期 */
  ORDER BY S.ClassID, S.StudentID