例1:要求存储过程从三个表的联接中返回所有学 生(提供了姓名)、选修的课程名称和成绩。 USE school GO IF EXISTS(SELECT name FROM sysobjects WHERE name ='student info all ANd type DROP PROCEDURE student info all GO CREATE PROCEDURE student info all AS SELECT Sname, cname, grade FROM S INNER JOIN SC ON S sno=sc sno INNER JOIN C ON SC cno=c cno GO 2021/2/20 Information College. ChangJun10 2021/2/20 Information College · ChangJun 例1：要求存储过程从三个表的联接中返回所有学 生（提供了姓名）、选修的课程名称和成绩。 USE school GO IF EXISTS (SELECT name FROM sysobjects WHERE name = ‘student_info_all' AND type = 'P') DROP PROCEDURE student_info_all GO CREATE PROCEDURE student_info_all AS SELECT sname, cname, grade FROM s INNER JOIN sc ON s.sno=sc.sno INNER JOIN c ON sc.cno=c.cno GO