Home
Output parameters should be assigned
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