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

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.