【Windows Form 实战】学生成绩管理系统(八) 管理员模块设计3 视图和存储过程

1、班级视图

create view [Class_View]asselect distinct(sclass)from TableStudent;GO

2、成绩视图

create View [S_C_Score_View]asselect B.sname, B.snum, C.cname, C.cnum, A.scorefrom SC A, TableStudent B, TableCourse Cwhere A.snum = B.snum and A.cnum = C.cnum; GO

3、删除学生 存储过程

create procedure [spDeleteStudent]( @snum int )asbegindelete from TableStudentwhere snum = @snum;delete from SCwhere snum = @snum;delete from Loginwhere userID = @snum;endGO

4、删除教师 存储过程

create procedure [spDeleteTeacher]( @tnum int )asdeclare @cnum intBeginselect * into tfrom TableTeacherwhere tnum = @tnum;select @cnum = cnum from t;if @cnum is not null    begin    update TableCourse  set tnum = null where cnum = @cnum;    enddelete from TableTeacher where tnum = @tnum;drop table t;EndGO

源代码文件下载地址