1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Bài tập

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.

Hướng dẫn

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.