Declare multiple variables
You've seen how to DECLARE
and SET
set 1 variable. Now, you'll DECLARE
and SET
multiple variables. There is already one variable declared, however you need to overwrite this and declare 3 new ones. The WHERE
clause will also need to be modified to return results between a range of dates.
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Declare @start
-- SET @start to '2014-01-24'