WISE OWL EXERCISES
SQL EXERCISES
SQL EXERCISES
- Simple Queries (4)
- Setting criteria using WHERE (5)
- Calculations (7)
- Calculations using dates (4)
- Basic joins (8)
- More exotic joins (2)
- Aggregation and grouping (8)
- Views (5)
- Subqueries (5)
- Stored procedures (5)
- Variables (8)
- Parameters and return values (11)
- Testing conditions (1)
- Looping (3)
- Scalar functions (6)
- Transactions (5)
- Creating tables (5)
- Temporary tables and table variables (9)
- Table-valued functions (6)
- Derived tables and CTEs (13)
- Dynamic SQL (4)
- Pivots (2)
- Triggers (2)
- Archived (70)
SQL exercises on TEMPORARY TABLES AND TABLE VARIABLES
This page lists the 9 exercises about Temporary tables and table variables in SQL on our website:
| Software: | SQL |
| Version: | Any version of SQL Server |
| 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. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| 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. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Temporary tables and table variables |
| Level: | Relatively easy |
| Course: | Advanced SQL |
| Exercise: | Try both methods of creating Temporary tables, using INTO and CREATE. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Temporary tables and table variables |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Use a table variable to hold useful information from several sources together. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Temporary tables and table variables |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Use a table variable to join one set of data to another table. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Temporary tables and table variables |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Add rows one by one within a loop into a temporary table that you've created. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| 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. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| 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. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| 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. |
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