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 an in-line table-valued function to return all of the courses which occur between 2 dates which you pass into the function as parameters.

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 a function which - given a resource name - locates its id and returns a table of all courses having this resource id in a comma-delimited id list.

Go to exercise ...

Category: SQL
Topic: Table-valued functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a function to show all directors/actors whose names contain a given string.

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

This page has 0 threads Add post