Home

Function and procedure names should comply with a naming convention

Rule description

  • Function and procedure names should comply with a naming convention

 

Non-compliant Code Example

CREATE procedure [DATA].sp_GetFullname_  --Non compliant code (Procedure names is not comply with a naming convention)
@fname nvarchar(10),
@lname nvarchar(10) 
AS
BEGIN
    select [DATA].[GetFullName](@fname, @lname)
END
CREATE function [DATA].GetFullName_(@fname nvarchar(10), @lname nvarchar(10))  --Non compliant code (Function names is not comply with a naming convention)
returns nvarchar(20)
AS
BEGIN
    -- Check the employee
    RETURN (@fname + ', ' + @lname)
END
Visual Expert 2020
 VETSQLRULE35