存储过程
来源:互联网 发布:log4j json 编辑:程序博客网 时间:2024/05/16 12:31
/*创建名称为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