1. Write a Procedure that inputs Update SQL statement to be executed as a string and department ID.Update statement will update department name where departmentID is added with the help of parameter.
2. Add the functionality to store procedure which can execute the Update SQL statement dynamically.
3. Show execution of the store procedure.

Answer rating: 100% (QA)

To create a stored procedure in SQL that takes an update SQL statement as a string and a department ID as a parameter and then executes the update dyn... View the full answer