> > >

Air Traffic Control MCQs

Analyze the following code snippet for creating a stored procedure in SQL Server 2008:
CREATE PROCEDURE Person.GetEmployees
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
SET NOCOUNT ON
SELECT FirstName, LastName, JobTitle, Department
FROM Person.EmployeeDepartment
WHERE FirstName = @FirstName AND LastName = @LastName
GO
Which of the following is a valid code to execute the GetEmployees stored procedure?

EXECUTE Person.GetEmployees N'John', N'Miller'

EXEC Person.GetEmployees @LastName = N'Miller', @FirstName = N'John'

EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller'

All of the above

Answer

Correct Answer:

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Air Traffic Control Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it