DBI202Xuất hiện trong 1 đề thi
Create a stored procedure named GetEmployeeByID that accepts an EmployeeID as a parameter and returns the corresponding employee's details.
Các lựa chọn
ACREATE PROCEDURE GetEmployeeByID
@EmployeeID INT
AS
BEGIN
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;
BCREATE PROCEDURE GetEmployeeByID
Declare @EmployeeID INT
AS
BEGIN
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;
CCREATE PROCEDURE GetEmployeeByID
@EmployeeID INT
AS
BEGIN
SELECT * FROM Employees;
END;
DCREATE PROCEDURE GetEmployeeByID
AS
BEGIN
Declare @EmployeeID INT
SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;
END;