资 源 简 介
AllCourse:
create
proc AllCourse
as
begin
select x.CourseID,x.CourseName,x.Point
,y.TeacherName,y.Post,z.Location,x.StuNumber
from Course x,TeacherTable1 y,TeachTable z
where
x.CourseID=z.CourseID and y.TeacherID=z.TeacherID
end
DeleteLogon :
create
proc DeleteLogon(@id char(10))
as
begin
dele