NYC Borough statistics results

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

Latihan ini adalah bagian dari kursus

Writing Functions and Stored Procedures in SQL Server

Petunjuk latihan

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.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

-- 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 
___ ___ 
___ ___;

Edit dan Jalankan Kode