Execute scalar with select

Previously, you created a scalar function named SumRideHrsDateRange(). Execute that function for the '3/1/2018' through '3/10/2018' date range by passing local date variables.

Bu egzersiz

Writing Functions and Stored Procedures in SQL Server

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Create @BeginDate and @EndDate variables of type date with values '3/1/2018' and '3/10/2018'.
Execute the SumRideHrsDateRange() function by passing @BeginDate and @EndDate variables.
Include @BeginDate and @EndDate variables in your SELECT statement with the function result.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Create @BeginDate
___ ___ AS date = '___'
-- Create @EndDate
___ ___ ___ ___ = '3/10/2018' 
SELECT
  -- Select @BeginDate
  ___ AS BeginDate,
  -- Select @EndDate
  ___ AS EndDate,
  -- Execute SumRideHrsDateRange()
  dbo.___(___, ___) AS TotalRideHrs

Kodu Düzenle ve Çalıştır