sql 預存程序取值

一般的預存程序取值，有select查詢，output輸出參數，return傳回值,raiserror 值，其中return必有傳回值，如不指定return值，將返回0

SET NOCOUNT ON；設定是否返回受影響的行

多語句，取受影響的行數結果不準確

1, select 查詢表資料返回

CREATE PROCEDURE [dbo].[GetMaxIssue]
AS
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT max( issue) as maxissue  from b_issuelist
END

 

2，OUTPUT參數取值

CREATE PROCEDURE [dbo].[GetMaxIssue]
@Maxissue int output
AS
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT @Maxissue = max( issue)  from b_issuelist
END

 

3,傳回值取值

CREATE PROCEDURE [dbo].[GetMaxIssue]
@Maxissue int output
AS
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT @Maxissue = max( issue)  from b_issuelist   --OUTPUT 參數
return @maxissue + 1   --傳回值
END

 

還有 raiserror 暫無執行個體