-- Scalar function with no input parameters
CREATE FUNCTION GetTomorrow()
RETURNS date AS BEGIN
RETURN (SELECT DATEADD(day, 1, GETDATE()))
END
單一參數的純量 UDF
-- Scalar function with one parameter
CREATE FUNCTION GetRideHrsOneDay (@DateParm date)
RETURNS numeric AS BEGIN
RETURN (
SELECT
SUM(
DATEDIFF(second, PickupDate, DropoffDate)
)/ 3600
FROM
YellowTripData
WHERE
CONVERT (date, PickupDate) = @DateParm
) END;
兩個輸入參數的純量 UDF
-- Scalar function with two input parameters
CREATE FUNCTION GetRideHrsDateRange (
@StartDateParm datetime, @EndDateParm datetime
) RETURNS numeric AS BEGIN RETURN (
SELECT
SUM(
DATEDIFF(second, PickupDate, DropOffDate)
)/ 3600
FROM YellowTripData
WHERE
PickupDate > @StartDateParm
AND DropoffDate < @EndDateParm
) END;
Preparing Video For Download...
