Zoom
Question 6:
[1] Create a stored procedure named proc_service Ticket_part to count distinct parts
belonging to a given service ticket
where @service TicketID int is an input parameter, and @numberOfParts int is an output
parameter of the procedure.
For example, when we execute the procedure proc_service Ticket_part by using the following
statements, the result should be as in the following figure:
declare @x int
exec proc_service Ticket_part 10111236, @x output
select @x
(No column name)
3
Picture 6.1
Question 7:
[1] Create a trigger named tr_insert_car for the insert statement on table Cars so that
when we insert one car into the table Cars, the system will display all cars whose year,
model are the same inserted car's year, model
The result includes: carID, serialNumber, model, colour, year.
6 of 6
Paper No: 1
100%
Close
