RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Access DB
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
What is SP
Enforcing Business Rules
Creating SP
User Defined SP
Stored Procedures - Exercise
Modifying Procedures
Deleting Stored Procedures
System Extended SP
Error Handling
Using Output Parameters
Executing Stored Procedures
Testing Stored Procedures
Different SP Conclusion
Stored Procedure - Quiz
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
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.
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