Microsoft SQL training exercises | Parameters and return values

Showing exercises 1-8 (out of 8)

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: Relatively easy
Course: Advanced SQL
Exercise: Create a procedure which takes one parameter (the name of a category) and selects all websites in that category.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a stored procedure to show all delegates from a training database where the company name and category name equal parameters (which can be null).

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: Create a procedure to show all websites from a table which went online between two given dates, passed as parameters and taking default values.

Go to exercise ...

Category: SQL
Topic: Parameters and return values
Level: Harder than average
Course: Advanced SQL
Exercise: Check if a given resource exists, then count courses containing its id (in a comma-delimited list) and return count using output parameter or return value.

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

This page has 0 threads Add post