Question: Create a stored procedure that uses a cursor to iterate through all of the films in the film table and update the rental _ duration
Create a stored procedure that uses a cursor to iterate through all of the films in the film table
and update the rentalduration values. For durations set the rental duration to For
durations between and set the duration to For durations set the duration to Be
sure to use proper error handling and transaction processing in your stored procedure. Paste
the stored procedure below and show the durations from the following films to test your stored
procedure.
a
b
c
d
e
f
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
