青云测评_Java开发_题目_JAVA

首页 > 知识中心 > Java开发 > AAA277

题目级别：工程师【适中】

分析以下在SQL Server中创建存储过程的代码片段：
    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
以下哪项是执行 GetEmployees 存储过程的有效代码？(     )

备选答案

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'

都不是