1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

अभ्यास

Use SP to INSERT

Create a stored procedure named cusp_RideSummaryCreate in the dbo schema that will insert a record into the RideSummary table.

निर्देश

100 XP
  • Define two input parameters named @DateParm and @RideHrsParm.
  • Insert @DateParm and @RideHrsParm into the Date and RideHours columns of the RideSummary table.
  • Select the record that was just inserted where the Date is equal to @DateParm.