Stored Procedures  «Prev  Next»

Creating Stored Procedures Exercise

Objective: Practice creating user-defined Stored Procedure

Exercise Scoring

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.

Submitting the exercise

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