【正确答案】USE Student
   iF EXISTS(SELECT name FROM sysobjects
       WHERE name='proc_CourInfo'AND type='p')
       DROP ROCEDURE proc_CourInfo
   GO
   CREATE PROCEDURE proe_CourInfo
   AS
   SELECT*
   FROM Courses
   GO