numberOfBookings int is the output parameter of the procedure.
declare @x int
exec P1 1, @x output
select @x as NumberOfBookings
6 of 6
Paper No: 9
NumberOfBookings
1
Picture 8.1
1
Question 9:
Create a trigger named T1 for the delete statement on the "booking" table so that when we call a delete statement to delete one or more rows from the "booking" table, the system will automatically delete also from the "baggage" table all the baggage of the deleted bookings.
FUO
Close
+ 100%
Zoom
