Home

Local variable and parameter names should comply with a naming convention

Rule description

  • Local variable and parameter names should comply with a naming convention

 

Non-compliant Code Example

CREATE Procedure [DATA].sp_GetFullname
@fname nvarchar(10),
@mname nvarchar(10),
@@lname nvarchar(10) --Non compliant code (Procedure parameter name is not comply with a naming convention)
AS
BEGIN
	select [DATA].[GetFullName](@fname, @mname)
END

Compliant Code Example

CREATE Procedure [DATA].sp_GetFullname
@fname nvarchar(10),
@lname nvarchar(10) --Compliant code (Procedure parameter name is comply with a naming convention)
AS
BEGIN
	select [DATA].[GetFullName](@fname, @lname)
END
Visual Expert 2020
 VETSQLRULE54