This page has 0 threads | Add post

Exercises

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

Software ==>	SQL (203 exercises)
Topic ==>	Calculations (18 exercises)
Level ==>	Relatively easy
Subject ==>	SQL training

Create calculated columns in SQL queries which concatenate multiple values to form longer strings.

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 want to download the SQL Server database that this yields:

Go into SQL Server Management Studio;
Open the SQL file you've just unzipped (you can press CTRL + O to do this); then
Execute this script.

This will generate the database that you'll need to use in order to do this exercise (remember to refresh your list of databases to see it!). Note that any files provided are only to be used for exercises published on this website, and may not be reused or distributed in any form without the prior written permission of Wise Owl.

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/

Write a query to select the following fields from the Artist table:

Results of a simple SELECT statement in SQL Server Management Studio

The first few artists you should see.

Add a calculated column which concatenates the artist's name and type, wrapping the type of artist in round brackets.

Results of a SQL query with a calculated column which concatenates two text fields and some literal strings.

Don't forget to include a space after the artist name.

You can add the bits of text together using the + operator, or use the CONCAT function to do this.

Write another query which selects the following fields from the Track table:

A basic SQL SELECT statement showing a list of music tracks.

The first few tracks you should see.

Replace the Track_mins and Track_secs columns with a calculated column which concatenates the values as shown in the diagram below:

A calculated column in a SQL query concatenating text and numeric values.

The result of combining the values.

As you need to concatenate text and numbers in this example you'll find it easier to use the CONCAT function. If you use the + operator, you'll also need to control the data type of the numeric fields.

Save the script as String Along.sql and then close it.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here:

This page has 0 threads

Add a new post