存储过程

 

/*创建名称为query_student的存储过程*/

create procedure query_student

    @student_name   varchar(30)='%'

as

     select

         stu.name    as '姓名',

         stu.teacher_id    as '老师id号',

         tea.name    as '老师姓名'  

     from student stu

inner join teachers tea   

    on   stu.teacher_id=tea.id

 where stu.name like @student_name

go

execute    query_student '小%'

go

 

/*带学号参数的存储过程*/

create procedure proc_select_para_student

@id int

as

   select * from student where id=@id

go

execute proc_select_para_student 2001002

go

/*创建名字为proc_select_student_teacherr的存储过程*/

create    procedure   proc_select_student_teacher

as

select     s.id    as   '学生号',

s.name       as      '学生名',

s.teacher_id   as      '老师编号',

t.name        as       '老师姓名'

from

student s

inner join

teachers t

on

s.teacher_id=t.id

go

execute proc_select_student_teacher

go

 

/*使用系统存储过程sp_helptext*/

execute   sp_helptext   proc_insert_student

go