INSERT INTO @TABLE

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

Este exercicio faz parte do curso

Writing Functions and Stored Procedures in SQL Server

Instruções do exercicio

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.

exercicio interativo prático

Tente este exercicio completando este código de exemplo.

-- 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

Editar e Executar Código