29 2
30 2
Airport Terminal 4
Standard
SUV
2
0
Airport Terminal 7
Picture 7.1
Question 8:
Create a stored procedure named P1 to calculate the number of cars belonging to a given category, as well as the number of rentals involving cars of that category. The procedure has CategoryName (varchar(50)) as input parameter and NumberOfCars (int) and NumberOfRentals (int) as output parameters. For example, when running P1 by using the following statements, the result should be as in the following figure:
declare @x int, @y int
execute P1 'Compact', @x output, @y output
select @x as NumberOfCars, @y as NumberOfRentals
7 of 7
Paper No: 4
Zoom
+ 100%
Close
