Kizspy Question: 42
(Choose 1 answer)
Create a stored procedure named GetEmployeeByID that accepts an EmployeeID as a parameter and returns
the corresponding employee's details.
A. CREATE PROCEDURE GetEmployeeByID
@EmployeeID INT
AS
BEGIN
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;
B. CREATE PROCEDURE GetEmployeeByID
Declare @EmployeeID INT
AS
BEGIN
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;
C. CREATE PROCEDURE GetEmployeeByID
@EmployeeID INT
AS
BEGIN
SELECT * FROM Employees;
END;
D. CREATE PROCEDURE GetEmployeeByID
AS
BEGIN
Declare @EmployeeID INT
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;
