Home

Rule description

• Output parameters should be assigned

Non-compliant Code Example

CREATE PROCEDURE GetImmediateManager  
   @employeeID INT,  
   @managerID INT OUTPUT   -- Non compliant code (OUTPUT parameter is not assigned)
AS  
BEGIN  
   SELECT ManagerID
   FROM HumanResources.Employee
   WHERE EmployeeID = @employeeID  
END

Compliant Code Example

CREATE PROCEDURE GetImmediateManager  
   @employeeID INT,  
   @managerID INT OUTPUT  
AS  
BEGIN  
   SELECT @managerID = ManagerID --Compliant code (OUTPUT parameter is assigned)
   FROM HumanResources.Employee
   WHERE EmployeeID = @employeeID  
END