SQL exercises on VARIABLES

This page lists the 8 exercises about Variables in SQL on our website:

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Declare 3 variables to hold different data types.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Using variables create a summary output window of aggregated data.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a simple stored procedure with a single variable to work out your age, and then print it out.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a variable holding a row id to get at the details for a row.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Read a list of the enemies of Doctor Who into a string variable.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Filtering a stored procedure using variables.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Harder than average
Course: Advanced SQL
Exercise: Create a list variable to store all the events released in a specified year.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Variables
Level: Harder than average
Course: Advanced SQL
Exercise: Given the name of a Doctor Who, use variables to print details for him.

Go to exercise ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post