Develop and test the following stored procedures.

 

1. A procedure that accepts an employee number and lists all information for that employee.  Display a message if the employee number is invalid.
2. A procedure that accepts a date as a parameter and displays the employee number and first and last names for all employees who were born on or after that date.  Print a message if no employees meet the criteria.
3. A procedure that accepts a store code as a parameter and displays the first and last names and date of birth for all employees who work in that store.  Place the listing in alphabetical order by last and first names.  Display a message if the store code is invalid.
4. A procedure that accepts an employee code and a store code as parameters and prints a message as to whether that employee works in that store.   Print a message if the store code or employee code is invalid.

Answer rating: 100% (QA)

1 Procedure to List Employee Information DELIMITER CREATE PROCEDURE GetEmployeeInfoIN empNumber INT ... View the full answer