create proc test
@inta int,
@intb int=0
as
set nocount on
begin
return @inta+@intb
end
--demo
declare @intReturnValue int
exec @intReturnValue=test 3
select @intReturnValue
exec @intReturnValue=test 3,2
select @intReturnValue
-----------
3
(所影响的行数为 1 行)
-----------
5
(所影响的行数为 1 行)