where @depNo int is an input parameter and @sumOfSalarys int is an output parameter of
Kizspy. me the procedure.
Note: If the given @depNo does not exist then total salary will be 0
6 of 6
Paper No: 1
For example, when we execute the procedure proc_SumSalary by using the following
statements, the result should be as in the following figure:
declare @x int
exec proc_SumSalary 1, @x output
select @x as sumOfSalarys
Zoom
+ 98%
sumOf Salarys
55000
Close
