datacamp-logo
Session Ready
Exercise

Use SP to UPDATE

Create a stored procedure named cuspRideSummaryUpdate in the dbo schema that will update an existing record in the RideSummary table.

Instructions
100 XP
  • The SP should accept input parameters for each RideSummary column and be named @Date and @RideHrs.
  • Make @Date parameter a date data type and @RideHrs a numeric data type.
  • Use UPDATE and SET keywords to assign the parameter values to the RideSummary record where the @Date matches the Date value.