EXECUTE with OUTPUT & return value
Store and display both the output parameter and return code when executing dbo.cuspRideSummaryDelete SP.
Questo esercizio fa parte del corso
Writing Functions and Stored Procedures in SQL Server
Istruzioni dell'esercizio
- Create integer variables named
@ReturnStatusand@RowCount. - Pass
'3/1/2018'as the@DateParmvalue and executedbo.cuspRideSummaryDeleteSP. - Select
@ReturnStatusand@RowCountto understand the impact of the SP.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create @ReturnStatus
___ ___ AS ___
-- Create @RowCount
___ ___ AS ___
-- Execute the SP, storing the result in @ReturnStatus
___ ___ = ___.___
-- Specify @DateParm
___ = '3/1/2018',
-- Specify RowCountOut
@RowCountOut = @RowCount OUTPUT
-- Select the columns of interest
___
___ AS ReturnStatus,
___ AS 'RowCount';