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.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Create a local
numeric
variable named@RideHrs
. - Use
EXEC
to execute theSumRideHrsSingleDay
function and pass'3/5/2018'
as the input parameter. - Store the result of the function in
@RideHrs
variable.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create @RideHrs
___ ___ AS ___
-- Execute SumRideHrsSingleDay function and store the result in @RideHrs
___ ___ = dbo.___ @DateParm = '3/5/2018'
SELECT
'Total Ride Hours for 3/5/2018:',
@RideHrs