CREATE PROCEDURE with OUTPUT

Create a Stored Procedure named cuspSumRideHrsSingleDay in the dbo schema that accepts a date and returns the total ride hours for the date passed.

Cet exercice fait partie du cours

Writing Functions and Stored Procedures in SQL Server

Afficher le cours

Instructions

Create a stored procedure called cuspSumRideHrsSingleDay in the dbo schema.
Declare @DateParm as the input parameter and @RideHrsOut as the output parameter.
Don't send the row count to the caller.
Assign the query result to @RideHrsOut and include the RETURN keyword.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Create the stored procedure
___ ___ dbo.___
    -- Declare the input parameter
	___ date,
    -- Declare the output parameter
	___ numeric ___
AS
-- Don't send the row count 
___ ___ ___
BEGIN
-- Assign the query result to @RideHrsOut
___
	___ = SUM(DATEDIFF(second, StartDate, EndDate))/3600
FROM CapitalBikeShare
-- Cast StartDate as date and compare with @DateParm
WHERE CAST(StartDate AS date) = @DateParm
RETURN
END

Modifier et exécuter le code