Microsoft SQL training exercises | Temporary tables and table variables

Showing exercises 1-10 (out of 10)

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

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Temporary tables and table variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a temporary table to show all the organisations which are either in a particular sector or which employ more than a certain number of people.

Go to exercise ...

Category: SQL
Topic: Temporary tables and table variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a table variable, and insert into the table C# courses and courses given by a particular trainer - then list the results.

Go to exercise ...

Category: SQL
Topic: Temporary tables and table variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Use a temporary table to hold directors and actors born in 1969 - flower children.

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Temporary tables and table variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a blank temporary table, fill it with people, then use UPDATE statements to set the value of various null columns.

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Temporary tables and table variables
Level: Harder than average
Course: Advanced SQL
Exercise: Something to while away the time - convert a string of trainer ids into a string of table names, using any method you prefer!.

Go to exercise ...

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

Go to exercise ...

This page has 0 threads Add post