Microsoft SQL training exercises | Table-valued functions

Showing exercises 1-6 (out of 6)

Category: SQL
Topic: Table-valued functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a table-valued function to list events for a given year.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Relatively easy
Course: Advanced SQL
Exercise: List episodes made by any given doctor by using a table function in SQL.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Return a table of episodes for a series number and author, using a table-valued function.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create an inline tabled valued function taking two parameters.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Harder than average
Course: Advanced SQL
Exercise: Show episodes, listing companions or enemies according to parameter, using an MSTVF function.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Harder than average
Course: Advanced SQL
Exercise: Use a MSTVF to show categories, countries and continents that contain a given vowel.

Go to exercise ...

This page has 0 threads Add post