1. Обучение
    2. /
  2. Курса
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

упражнение

EXECUTE with OUTPUT & return value

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

Инструкции

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.