DECLARE a TABLE
Let's create a TABLE variable to store Shift data and then populate it with static values.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Use
DECLARE
to create aTABLE
variable named@Shifts
- The
@Shifts
table variable should have the following columns -StartDateTime
andEndDateTime
- both ofdatetime
data type. - Populate the table variable with the values
'3/1/2018 8:00 AM'
and'3/1/2018 4:00 PM'
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Declare @Shifts as a TABLE
___ ___ ___(
-- Create StartDateTime column
___ ___,
-- Create EndDateTime column
___ ___)
-- Populate @Shifts
___ ___ ___ (StartDateTime, EndDateTime)
SELECT '3/1/2018 8:00 AM', '3/1/2018 4:00 PM'
SELECT *
FROM @Shifts