【正确答案】USE Student
   IF EXISTS(SELECT name FROM sysobjects
       WHERE name='proc_TeaDep'AND type='p')
       DROP PROCEDURE proc_TeaDep
   GO
   CREATE PROCEDURE proc_TeaDep
   @TeacherId char(5)
   AS
   SELECT Department_name
   FROM Departments d INNER JOIN Teachers t
   ON d.Department_id=t.Teacher_department
   WHERE t.Teacher_id=@TeacherId
   GO