Kizspy.me
5
5G
59
Bao
Kiet
Picture 8.1
Question 9:
[0.5 mark] Create a procedure named proc_report to count students belonging to a
department.
Where @deptname varchar(50) is an input parameter, @result INT is an output parameter
of the procedure.
For example, when we execute the procedure proc_report by using the following statements,
the result should be as in the following figure:
declare @x int
exec proc_report 'Mathematics', @x output
select @x as 'result'
Zoom
+ 93%
Close
