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 B. Option B. 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

(22 responses)

A
5% (1)
B
73% (16)
C
14% (3)
D
9% (2)

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 procedures#parameters#CREATE PROCEDURE#T-SQL

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice