/*
创建名称为
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