Question: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? 

A EXECUTE Person.GetEmployees N'John', N'Miller' 
B EXECUTE Person.GetEmployees N'John', N'Miller' 
C EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller' 
D All of these 

+ Answer
D 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description