The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due date of 1 September, 2020. However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes. Task Add a tire change maintenance task for every car and rollback the changes.
The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due date of 1 September, 2020. However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes.
Add a tire change maintenance task for every car and rollback the changes.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due date of 1 September, 2021. However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes.
COMMIT TRANSACTION;
PRINT 'Tire change maintenance task added for all cars with due date of 1 September, 2020.';
END
by Bartleby Expert
