无标题1.sql

来自「原代码详细说明是关于c++方面的希望可以帮助大家使用」· SQL 代码 · 共 24 行

create procedure getCourseName
as
   select distinct course.course_name from score,course where score.course_id=course.course_id

create procedure stat @course_name char(30),@avg_score float output
as 
   begin
       declare @count int
       select @count=count(*),@avg_score=avg(score) from student,score,course where student.stud_id=score.stud_id and score.course_id=course.course_id and course.course_name like @course_name
       select student.stud_id as 学号,student.stud_name as 姓名,score.score as 成绩 from student,score,course where student.stud_id=score.stud_id and score.course_id=course.course_id and course.course_name like @course_name
       return @count
end
exec getCourseName

declare @s int
declare @p float
exec @s=stat "C语言程序设计",@p  output
print @s
print @p


       declare @count int
       select @count=count(*) from student,score,course where student.stud_id=course.stud_id and score.course_id=course.course_id and course.course_name like 'C语言程序设计'
       print @count