Write Procedure that inputs old_Manager_ID and new_manager_id. This store procedure will update all the departments with the
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write Procedure that inputs old_Manager_ID and new_manager_id. This store procedure will update all the departments with the old manager ID to the new manager id which is supplied as input parameters.
- Write statement in the store procedure that will update old_manager_id to new_manager_id for all the departments.
- Use returning clause to return all the updated rows by the update statement.
- Show execution of the store procedure.
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date: