【SQL Sever】 存储过程的创建和执行

--无参的存储过程创建
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