8 of 8
Question 8:
[1] Create a stored procedure named proc_mechanic_service Ticket to calculate the count of distinct service Ticket belonging to a given mechanic person
where @mechanic decimal(18,0) is an input parameter and @numberOfservice Tic int is an output parameter of the procedure.
For example, when we execute the procedure proc_mechanic_service Ticket by using the following statements, the result should be as in the following figure:
declare @t int
declare @a decimal(18,0)
set @a= 41051230026
exec proc_mechanic_service Ticket @a, @t output
select @t as 'number of service ticket'
Paper No: 1
+ 100%
Zoom
Close
