SQL exercises on TABLE-VALUED FUNCTIONS

This page lists the 6 exercises about Table-valued functions in SQL on our website:

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
Topic: Table-valued functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create an inline tabled valued function taking two parameters.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post