1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server

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.