Use SP to DELETE
Create a stored procedure named cuspRideSummaryDelete
in the dbo schema that will delete an existing record in the RideSummary
table and RETURN
the number of rows affected via output parameter.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Create a stored procedure called
cuspRideSummaryDelete
that accepts@DateParm
as an input parameter and has an integer output parameter named@RowCountOut
. - Delete the record(s) in the
RideSummary
table that have the sameDate
value as@DateParm
. - Set
@RowCountOut
to@@ROWCOUNT
to return the number of rows affected by the statement.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create the stored procedure
CREATE PROCEDURE dbo.cuspRideSummaryDelete
-- Specify @DateParm input parameter
(___ ___,
-- Specify @RowCountOut output parameter
___ ___ ___)
AS
BEGIN
-- Delete record(s) where Date equals @DateParm
___ FROM dbo.___
___ ___ = ___
-- Set @RowCountOut to @@ROWCOUNT
___ ___ = ___
END;