SQL exercises on TEMPORARY TABLES AND TABLE VARIABLES

This page lists the 13 exercises about Temporary tables and table variables in SQL on our website:

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Relatively easy
Exercise:	Declare a table variable, and copy the Dr Who companions, enemies and doctors into it.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Relatively easy
Exercise:	Try both methods of creating Temporary tables, using INTO and CREATE.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Relatively easy
Exercise:	Use a temporary table in SQL Server to store a list of concerts cancelled due to COVID.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Relatively easy
Exercise:	Write SQL to put Dr Who rows in a temporary table, and add companions and enemies into this.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Add rows one by one within a loop into a temporary table that you've created.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Use a table variable in SQL Server to store a list of non-charting albums and singles.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Use a table variable to hold useful information from several sources together.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Use a table variable to join one set of data to another table.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Use a temporary table in SQL Server to compile a list of chart-topping albums and singles.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Average difficulty
Exercise:	Use a temporary table or table variable to combine the best Doctor Who episodes into a single table.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Harder than average
Exercise:	Use a table variable or temporary table to build up a list of database problems in a single table.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Harder than average
Exercise:	Use a temporary table or a table variable to collate a set of concert statistics in SQL Server.

Show this exercise

Software:	SQL
Topic:	Temporary tables and table variables
Level:	Harder than average
Exercise:	Write the names of your stored procedures and functions to a temporary table or table variable.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post