1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Exercise

EXEC scalar

You created the SumRideHrsSingleDay function earlier in this chapter. Execute that function using the EXEC keyword and store the result in a local variable.

Instructions

100 XP
  • Create a local numeric variable named @RideHrs.
  • Use EXEC to execute the SumRideHrsSingleDay function and pass '3/5/2018' as the input parameter.
  • Store the result of the function in @RideHrs variable.