You need to create a stored procedure that passes in a person's name and age. Which statement should you use to create the stored procedure?

The correct answer is C. Option C. Example (nvarchar and int are best here): The following example creates a stored procedure that returns information for a specific employee by passing values for the employee's first name and last name. This procedure accepts only exact matches for the parameters passed. CREATE…

Understanding Databases

Question

Exhibit

Options

AOption A
BOption B
COption C
DOption D

How the community answered

(14 responses)

A
7% (1)
C
86% (12)
D
7% (1)

Explanation

Example (nvarchar and int are best here): The following example creates a stored procedure that returns information for a specific employee by passing values for the employee's first name and last name. This procedure accepts only exact matches for the parameters passed. CREATE PROCEDURE HumanResources.uspGetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) SELECT FirstName, LastName, JobTitle, Department FROM HumanResources.vEmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName;

Topics

#stored procedure#SQL parameters#CREATE PROCEDURE#T-SQL

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice