USE 教学管理
GO
CREATEPROCEDURE P_学生部分信息
ASSELECT 学号,姓名,专业,所在院系,籍贯
FROM 学生表
USE 教学管理
IFEXISTS(SELECT*FROM sysobjects WHERE name='SC_infor'ANDtype='p')BEGINDROPPROCEDURE SC_infor
END
GO
CREATEPROCEDURE SC_infor(@smajorCHAR(20),@cnameCHAR(20))AS
SELECTS.sno,sname,smajor,sdepa,O.cno,cname,grade
FROM student S, enrollment E, offering O, course C
where smajor=@smajorAND cname=@cnameAND S.sno=E.sno
AND E.ono=O.ono
AND O.cno=C.cno
GO