declare @x int, @y int
execute P1 'Compact', @x output, @y output
select @x as NumberOfCars, @y as NumberOfRentals
7 of 7
Paper No: 4
NumberOfCars
NumberOfRentals
9
24
Question 9:
Picture 8.1
1
Create a trigger named update Rentals for the UPDATE statement on the Rentals table. This trigger should automatically recalculate and update the TotalAmount whenever the
Close
+ 100%
Zoom