SQL exercises | Parameters and return values

Showing exercises 1-11 (out of 11)

Category: SQL
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.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a stored procedure with NULLs as the default values.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Average difficulty
Course: Advanced SQL
Exercise: Filter in a stored procedure using a parameter.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Average difficulty
Course: Advanced SQL
Exercise: Create stored procedures with default values for the parameters.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a procedure to list out the companions for a given doctor.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

Category: SQL
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.

Go to exercise ...

This page has 0 threads Add post