SQLConfiguration
SQLConfiguration
SiteMap
Database Creation
Cursors Views
Business Rules
Stored Procedures
«Prev
Next»
Business Rules
Transaction Locking
Transaction Isolation - Quiz
Error Handling Testing
Server Interaction
Assign Use Variables
SQL Raising Errors
SQL Server Functions
SQL-Server Triggers
SQL Triggers-Quiz
Enforcing Business Rules
Creating Triggers - Exercise
Testing SQLserver Trigger
Stored Procedures
Stored Procedures - Exercise
Stored Procedure - Quiz
Modifying Procedures
Error Handling
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
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.
Submit