SQL exercises on TABLE-VALUED FUNCTIONS

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

Software:	SQL
Topic:	Table-valued functions
Level:	Relatively easy
Exercise:	Create a table valued function in SQL Server to return statistics about concerts in a given year.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SQL
Topic:	Table-valued functions
Level:	Average difficulty
Exercise:	Create a table-valued function in SQL Server to return a list of singles, albums and tours whose names match a search string.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post