Creating Stored Procedures Exercise

This exercise is worth a total of 20 points. You will receive 20 points for accurately creating the Transact-SQL statement that creates a stored procedure, as described in the instructions.

Construct a stored procedure, named usp_GetLastName, that accepts one input parameter named EmployeeID and returns (using a SELECT Transact-SQL statement) the last name of the employee.

Type or paste your Transact-SQL statement into the text box below, then click Submit to submit your answer and view a Results page.