Microsoft SQL training exercises | Scalar functions

Showing exercises 1-6 (out of 6)

Category: SQL
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a scalar function to include each Dr Who's incarnation dates in a query.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a function to show when a course ends, given its start date and how long it lasts, and use this function in a query.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Use an SQL function within a query to find out the part number of any Dr Who episode.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Write a function to count the number of values in a comma-delimited string (and hence the number of trainers assigned to a course).

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Create all sorts of scalar functions in SQL to return info about Dr Who episodes from within a query.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Create a function to return the country domain (eg .uk) from a website address, using REVERSE, CHARINDEX, etc.

Go to exercise ...

This page has 0 threads Add post