Exercise

EXECUTE with return value

Execute dbo.cuspRideSummaryUpdate to change the RideHours to 300 for '3/1/2018'. Store the return code from the stored procedure.

Instructions

100 XP

Declare @ReturnStatus as an integer and assign its value to the result of dbo.cuspRideSummaryUpdate.
Execute the stored procedure, setting @DateParm to '3/1/2018' and @RideHrs to 300.
Select the @ReturnStatus to see its value as well as the '3/1/2018' record from RideSummary to see the impact of the SP update.