不，你可以自己返回一些东西

No, you can return something yourself

示例

CREATE PROC pr_test AS 
SELECT 1/0

RETURN 0
GO

现在运行它

DECLARE @i INT
exec @i = pr_test

SELECT @i  -- will be 0

DROP PROC pr_test

现在让我们在没有 return 语句的情况下再做一次

Now let's do it again without the return statement

CREATE PROC pr_test2 AS 
SELECT 1/0

GO

DECLARE @i INT
exec @i = pr_test2

SELECT @i  -- will be - 6

***使用输出参数来传回状态和/或消息

Better to use an output parameter to pass back statuses and or messages