1. 学习
    2. /
  2. 课程
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

练习

NYC Borough statistics results

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

说明

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.