实训2.sql

SQL2000跟课件学习的源代码 分享共同学习

CREATE PROCEDURE spclass_term_course @class char(12) ,@term tinyint AS
SELECT dbo.Class.ClassName AS 班级名, dbo.Speciality_Course.Term AS 开课学期, 
      dbo.Course.CourseName AS 课程名
FROM dbo.Speciality_Course INNER JOIN
      dbo.Class ON 
      dbo.Speciality_Course.SpecialityID = dbo.Class.SpecialityID INNER JOIN
      dbo.Course ON dbo.Speciality_Course.CourseID = dbo.Course.CourseID
where Class.ClassName=@class and dbo.Speciality_Course.Term=@term

exec spclass_term_course '计应0501',2