SqlServer如何获取存储过程的返回值

1.Output参数返回值

CREATE PROCEDURE [dbo].[upInformation](
@age int ,
@id bigint OUTPUT
)
AS
BEGIN
SET NOCOUNT ON;
BEGIN
INSERT INTO [Information](age )
VALUES (@age )
SET @id = @@IDENTITY
END
END

2.Return过程返回值

CREATE PROCEDURE [dbo].[upInformation](
@age int ,
@id bigint OUTPUT
)
AS
BEGIN
SET NOCOUNT ON;
IF(EXISTS(SELECT * FROM [Shop] WHERE [s_id] = @age ))
BEGIN
INSERT INTO [Information](age ) VALUES (@age )
SET @id = @@IDENTITY
RETURN 1 — 插入成功返回1
END
ELSE
RETURN 0 — 插入失败返回0
END

3.Select数据集返回值

CREATE PROCEDURE [dbo].[upInformation](
@id int
)
AS
BEGIN
SET NOCOUNT ON;
SELECT id,age FROM [Information]
WHERE id = @id
GO