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.