CREATE PROCEDURE PR_Sum
@a int,
@b int,
@sum int output
AS
BEGIN
set @sum=@a+@b
END
--调用存储过程
declare @sum2 int
exec PR_Sum 1,2,@sum2 output
print @sum2
SqlServer存储过程(output参数)
最新推荐文章于 2023-06-07 23:50:10 发布
CREATE PROCEDURE PR_Sum
@a int,
@b int,
@sum int output
AS
BEGIN
set @sum=@a+@b
END
--调用存储过程
declare @sum2 int
exec PR_Sum 1,2,@sum2 output
print @sum2