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

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.