USE [Net6Demo]
GO
/****** Object:  StoredProcedure [dbo].[TestProc]    Script Date: 2022/12/15 11:43:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[TestProc]
(
    @Id BIGINT,                    --Id
                                 --公用参数：必需的
    @IdentityUserId BIGINT = NULL, --当前登录人Id
    @ResultStatus INT OUTPUT,      --执行结果编码 100成功 101失败
    @Msg NVARCHAR(MAX) OUTPUT      --错误信息
)
AS
BEGIN
    BEGIN TRY
        SET @ResultStatus = 100;

IF 1=2
BEGIN
    SET @ResultStatus = 101;
SET @Msg=N'错误的请求'
GOTO Tag;
END
        SELECT TOP 1 *
        FROM dbo.Sys_User ORDER BY ID;

SELECT TotalCount=COUNT(1)
        FROM dbo.Sys_User

Tag:

    END TRY
    BEGIN CATCH
        SET @ResultStatus = 101;
        SET @Msg = ERROR_MESSAGE();
    END CATCH;
END;