6 of 6
Paper No: 1
for example, when you execute the following statement, the system will display the results as
in the following figure:
insert into Cars(carID, serialNumber, model, colour, year)
values (11223344101, '83ABC83ABC83ABC83', 'toyota', 'Black', 2017)
(Note: the preview image is only sample, the result depends on entered data)
Results
carlD
Messages
serial Number
1
1122334475
2
11223344101
model colour year
13ABC13ABC13ABC13 toyota Gray 2017
83ABC83ABC83ABC83 toyota Black 2017
Picture 7.1
Zoom
Question 8:
[0.5] Create a stored procedure named proc_salesPerson_invoice to count distinct invoices
belonging to a given sales person
where @salesID decimal is an input parameter and @numberOfInvoices int is an output
parameter of the procedure.
For example, when we execute the procedure proc_salesPerson_invoice by using the
following statements, the result should be as in the following figure:
declare @t int
declare @a decimal(18,0)
set @a 30121050035
exec proc_salesPerson_invoice @a, @t output
select @t
100%
Close
