pro_stu_info.sql

来自「这是一个用PB做的学生成绩管理系统」· SQL 代码 · 共 12 行

//USE xscj
//IF EXISTS(Select name From sysobjects
//    where name='pro_stu_info' and type='p')
//   DROP PROCEDURE pro_stu_info

CREATE PROCEDURE pro_stu_info
AS
  Select stu_info.stu_id,stu_name,course.cls_id,cls_name,grade.score,show
  From stu_info,course,grade
  Where stu_info.stu_id=grade.stu_id and course.cls_id=grade.cls_id;