Home

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