【正确答案】USE Student
   IF EXISTS(SELECT name FROM sysobjects
   WHERE name='proc_RetrClass'AND type='p')
   DROP PROCEDURE proc_RetrClass
   GO
   CREATE PROCEDURE proc_RetrClass
   @Classld char(8)='2005011/%'
   AS
   SELECT Class_name
   FROM Classes
   WHERE Class_id ike @ClassId
   GO