作者:倒颠0 | 来源:互联网 | 2023-05-18 22:41
--无参的存储过程创建createprocedurepro_test1asbeginselect*fromstudentwherestuid1end--查询存储过程execpro_t
--无参的存储过程创建
create procedure pro_test1
as
begin
select * from student
where stuid=1
end
--查询存储过程
exec pro_test1
DECLARE @return_value int
EXEC @return_value = [dbo].[pro_test1]
SELECT 'Return Value' = @return_value
GO
--创建带默认参数存储过程
create procedure pro_test2
@stuid int =2
as
begin
select * from student
where stuid=@stuid
end
--删除存储过程
drop procedure pro_test3
--查询带默认参数存储过程
exec pro_test2 3
declare @stuid int=3
exec pro_test2 @stuid
--创建带输出参数的存储过程
create procedure pro_test3
@stuid int=4,
@stuname varchar(20) output,
@stubirthday varchar(20) output
as
begin
select @stuname=stuname,@stubirthday=stubirthday
from student
where stuid=@stuid
end
--调用带输出参数的存储过程
declare @stuid int,
@stu_name varchar(20) ,
@stu_birthday datetime
exec pro_test3
@stuid=6,
@stuname=@stu_name output,
@stubirthday=@stu_birthday output
select @stu_name,@stu_birthday