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参数)
最新推荐文章于 2024-08-11 21:37:22 发布
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