1. 学ぶ
    2. /
  2. コース
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

演習

EXECUTE with OUTPUT parameter

Execute the dbo.cuspSumRideHrsSingleDay stored procedure and capture the output parameter.

指示

100 XP
  • Declare @RideHrs as a numeric output parameter.
  • Execute dbo.cuspSumRideHrsSingleDay and pass '3/1/2018' as the @DateParm input parameter.
  • Store the output parameter value in @RideHrs.
  • Select @RideHrs to show the output parameter value of the SP.