INSERT INTO @TABLE

Instead of storing static values in a table variable, let's store the result of a query.

Diese Übung ist Teil des Kurses

<Kurs>Writing Functions and Stored Procedures in SQL Server</Kurs>

Übungsanweisungen

Declare a TABLE variable named @RideDates with the following columns RideStart and RideEnd.
Both table variable columns should be date data type.
SELECT the unique values of StartDate and EndDate from the CapitalBikeShare table. CAST them from datetime to date data types.
Store the query results in @RideDates.

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

-- Declare @RideDates
___ ___ ___(
    -- Define RideStart column
	___ ___, 
    -- Define RideEnd column
    ___ ___)
-- Populate @RideDates
___ ___ @RideDates(RideStart, RideEnd)
-- Select the unique date values of StartDate and EndDate
SELECT ___
    -- Cast StartDate as date
	___(___ as date),
    -- Cast EndDate as date
	___(___ as date) 
FROM CapitalBikeShare 
SELECT * 
FROM @RideDates

Code bearbeiten und ausführen