Microsoft SQL training exercises | Temporary tables and table variables

Showing exercises 1-5 (out of 5)

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: 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: 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: 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