Exercise

EXECUTE with OUTPUT & return value

Store and display both the output parameter and return code when executing dbo.cuspRideSummaryDelete SP.

Instructions

100 XP

Create integer variables named @ReturnStatus and @RowCount.
Pass '3/1/2018' as the @DateParm value and execute dbo.cuspRideSummaryDelete SP.
Select @ReturnStatus and @RowCount to understand the impact of the SP.

Take Hint (-30 XP)