1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Exercise

CREATE OR ALTER

Change the SumStationStats function to enable SCHEMABINDING. Also change the parameter name to @EndDate and compare to EndDate of CapitalBikeShare table.

Instructions

100 XP
  • Use CREATE OR ALTER keywords to update the SumStationStats function.
  • Change the parameter name to @EndDate and data type to date.
  • Compare the @EndDate to EndDate of the CapitalBikeShare table.
  • Enable SCHEMABINDING.