Microsoft SQL training exercises | Variables

Showing exercises 1-8 (out of 8)

Category: SQL
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a simple stored procedure with a single variable to work out your age, and then print it out.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a variable holding a row id to get at the details for a row.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Crreate two variables, and assign to them aggregate values from SELECT statements to compare people by status.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Read a list of the enemies of Doctor Who into a string variable.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a stored procedure to store the row count of a query in a variable, then redisplay it.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Harder than average
Course: Advanced SQL
Exercise: Using string concatenation and a variable, accumulate and then display the names of all of the delegates on a given training course.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Harder than average
Course: Advanced SQL
Exercise: Assign values from columns of a row of training courses to separate variables, using a single SELECT statement.

Go to exercise ...

Category: SQL
Topic: Variables
Level: Harder than average
Course: Advanced SQL
Exercise: Given the name of a Doctor Who, use variables to print details for him.

Go to exercise ...

This page has 0 threads Add post