DF029: Missing parameter(s) name in procedure call.

Last modified: December 25, 2024

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

Category

BEST PRACTICE

Message

Missing parameter(s) name in procedure call.

Description

It is recommended to explicitly specify parameter names when calling a stored procedure.

Additional information

Explicitly specifying parameter names when calling a stored procedure enhances code readability and reduces the likelihood of errors, especially in cases where the procedure has multiple parameters or default parameter values are involved. Additionally, specifying parameter names ensures that the values are assigned to the correct parameters in the procedure, even if the order of parameters changes in the future.

Noncompliant code example

DECLARE @output INT
EXEC @output = dbo.DemoProcedure 'SomeValueableData'

Compliant solution

DECLARE @output INT
EXEC @output = dbo.DemoProcedure @MyParameter = 'SomeValueableData'