Use SP to UPDATE
Create a stored procedure named cuspRideSummaryUpdate
in the dbo
schema that will update an existing record in the RideSummary
table.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- The SP should accept input parameters for each
RideSummary
column and be named@Date
and@RideHrs
. - Make
@Date
parameter adate
data type and@RideHrs
anumeric
data type. - Use
UPDATE
andSET
keywords to assign the parameter values to theRideSummary
record where the@Date
matches theDate
value.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create the stored procedure
___ ___ ___.___
-- Specify @Date input parameter
(___ ___,
-- Specify @RideHrs input parameter
___ numeric(18,0))
AS
BEGIN
SET NOCOUNT ON
-- Update RideSummary
___ ___
-- Set
___
___ = @Date,
___ = @RideHrs
-- Include records where Date equals @Date
___ ___ = ___
END;