Get startedGet started for free

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

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Declare @start


-- SET @start to '2014-01-24'
Edit and Run Code