Home

Unused procedure and function parameters should be removed

Rule description

  • Unused procedure and function parameters should be removed

 

Non-compliant Code Example

CREATE FUNCTION [DATA].CheckCustomer
    (@customer_Id int)    --Non compliant code (Unused parameter)
RETURNS bit
AS
BEGIN
    DECLARE @isChecked bit
    SET @isChecked = 1
    -- Check the employee
    RETURN @isChecked
END
Visual Expert 2020
 VETSQLRULE39