Session Ready
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.