1. Learn
  2. /
  3. Courses
  4. /
  5. 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.