Session Ready
Exercise

Your very own TRY..CATCH

Alter dbo.cuspRideSummaryDelete to include an intentional error so we can see how the TRY CATCH block works.

Instructions
100 XP
  • Incorrectly assign @DateParm a nvarchar(30) data type instead of a date.
  • Include @Error as an optional OUTPUT parameter.
  • Include the DELETE statement within the BEGIN TRY...END TRY block.
  • Concatenate the ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_MESSAGE(), ERROR_LINE() within the BEGIN CATCH...END CATCH block and SET to @Error.