Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
This page lists the 17 exercises about Parameters and return values in SQL on our website:
Software: | SQL |
Topic: | Parameters and return values |
Level: | Relatively easy |
Exercise: | Add parameters to a SQL stored procedure which returns a list of music albums. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Relatively easy |
Exercise: | Get a stored procedure to list the Dr Who episodes for a given enemy. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Relatively easy |
Exercise: | Use return values in SQL Server to pass values between stored procedures and return details of music albums. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Create a procedure to list out the companions for a given doctor. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Create a stored procedure in SQL Server using parameters to filter a list of venues. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Create a stored procedure to list Dr Who episodes for a series number, using a default parameter value. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Create a stored procedure with NULLs as the default values. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Create stored procedures with default values for the parameters. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Filter in a stored procedure using a parameter. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Use an output parameter to return a list variable of the most eventful continents. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Use optional parameters in SQL Server stored procedures to return a list of concerts. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Use return values in SQL Server to capture the result of a stored procedure. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Average difficulty |
Exercise: | Use return values to bring back an INT return value from a stored procedure. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Harder than average |
Exercise: | Count rows and pass the information out of a procedure using output parameters. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Harder than average |
Exercise: | Create a SQL stored procedure with multiple optional parameters. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Harder than average |
Exercise: | Return a continent name from one procedure, and pass the output value into another. |
Software: | SQL |
Topic: | Parameters and return values |
Level: | Harder than average |
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 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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.