EXECUTE with OUTPUT parameter
Execute the dbo.cuspSumRideHrsSingleDay stored procedure and capture the output parameter.
Bu egzersiz
Writing Functions and Stored Procedures in SQL Server
kursunun bir parçasıdırEgzersiz talimatları
- Declare
@RideHrsas anumericoutput parameter. - Execute
dbo.cuspSumRideHrsSingleDayand pass'3/1/2018'as the@DateParminput parameter. - Store the output parameter value in
@RideHrs. - Select
@RideHrsto show the output parameter value of the SP.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create @RideHrs
___ ___ AS ___(18,0)
-- Execute the stored procedure
___ dbo.___
-- Pass the input parameter
___ = '3/1/2018',
-- Store the output in @RideHrs
@RideHrsOut = ___ ___
-- Select @RideHrs
___ @RideHrs AS RideHours