This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SQL (203 exercises)
Topic ==>	Variables (11 exercises)
Level ==>	Relatively easy
Subject ==>	SQL training

Use variables to store the values used in the WHERE clause of SQL queries.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

If you don't have a copy of the Music_01 database, follow the instructions at the following link to create it: www.wiseowl.co.uk/sql/exercises/standard/using-sql-server/5257/

Open the file called Declaration of Love.sql from the folder shown above. You'll find two queries to return a list of albums and songs whose titles contain the word love. Run the query to see the results:

Lists of albums and songs containing the word love produced by a SQL query.

It's a popular topic!

Above the first SELECT statement in the script, declare a variable called @NameContains with a data type of NVARCHAR(255). Set the value of this variable to '%love%'.

The simplest syntax to assign an initial value to a variable is:

DECLARE @VariableName DATATYPE = Value

Modify the WHERE clause of each query to refer to the value of the @NameContains variable instead of the text '%love%'.

Execute the script to make sure you see the same results.

Declare another variable according to the following table: