NYC Borough statistics results

Let's see the results of the dbo.cuspBoroughRideStats stored procedure you just created.

Bu egzersiz, kursun bir parçasıdır

Writing Functions and Stored Procedures in SQL Server

Egzersiz talimatları

Declare @SPResults as a TABLE with the following columns of nvarchar (30) data types; Weekday, Borough, AvgFarePerKM, RideCount and TotalRideMin.
Execute dbo.cuspBoroughRideStats and insert the results into @SPResults.
Select all the records from @SPresults.

Uygulamalı etkileşimli egzersiz

Bu egzersizi bu örnek kodu tamamlayarak deneyin.

-- Create SPResults
___ ___ ___(
  	-- Create Weekday
	___ nvarchar(30),
    -- Create Borough
	___ nvarchar(30),
    -- Create AvgFarePerKM
	___ nvarchar(30),
    -- Create RideCount
	___	nvarchar(30),
    -- Create TotalRideMin
	___	nvarchar(30))

-- Insert the results into @SPResults
___ ___ ___
-- Execute the SP
___ ___.___

-- Select all the records from @SPresults 
___ ___ 
___ ___;

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