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 PARAMETERS AND RETURN VALUES
This page lists the 11 exercises about Parameters and return values in SQL on our website:
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Relatively easy |
| Course: | Advanced SQL |
| Exercise: | Get a stored procedure to list the Dr Who episodes for a given enemy. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Create a stored procedure with NULLs as the default values. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Filter in a stored procedure using a parameter. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Create stored procedures with default values for the parameters. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Use an output parameter to return a list variable of the most eventful continents. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Create a stored procedure to list Dr Who episodes for a series number, using a default parameter value. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Create a procedure to list out the companions for a given doctor. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Average difficulty |
| Course: | Advanced SQL |
| Exercise: | Use return values to bring back an INT return value from a stored procedure. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Harder than average |
| Course: | Advanced SQL |
| Exercise: | Return a continent name from one procedure, and pass the output value into another. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Harder than average |
| Course: | Advanced SQL |
| Exercise: | Count rows and pass the information out of a procedure using output parameters. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Parameters and return values |
| Level: | Harder than average |
| Course: | Advanced SQL |
| Exercise: | Return from a stored proecure the name of the country with the most events and how many events there were. |
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