Session Ready
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.