DF191: Stored procedure does not return result code.

Last modified: December 25, 2024

The topic describes the DF191 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

Stored procedure does not return result code.

Description

It is recommended to always return a result from stored procedures to indicate the outcome of the execution.

Noncompliant code example

EXEC dbo.DemoProcedure @prm = 1
GO

Compliant solution

DECLARE @ret INT
EXEC @ret = dbo.DemoProcedure @prm = 1
GO