Write a stored procedure that accepts a department ID and returns the employee name, department name, and salary.

Question

Assisting AI · Accepted Answer

A straightforward procedure:

```sql
CREATE PROCEDURE dbo.GetEmployeesByDept
    @DeptID INT
AS
BEGIN
    SELECT d.DepartmentName,
           e.EmployeeName,
           e.Salary
    FROM Employees e
    JOIN Departments d ON e.DepartmentID = d.DepartmentID
    WHERE e.DepartmentID = @DeptID;
END;
```

This returns all employees in the specified department. Complexity is O(m) where m is the number of employees in that department. Call it with `EXEC dbo.GetEmployeesByDept @DeptID = 3;`.

Write a stored procedure that accepts a department ID and returns the employee name, department name, and salary.

💡 Model Answer

🎤 Get questions like this answered in real-time