**Help with Database**

Select Language Powered by Google Translate Creating stored procedures, part 2 Exercise Objective:Practice creating a 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. 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