1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Bài tập

NYC Borough statistics results

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

Hướng dẫn

100 XP
  • 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.