Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in MS SQL Server

Introduction
Infinite looping
12. Mind infinity
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

Instruction

Great job! With this kind of looping query, it's important to always have a termination check that will end the query at some point. Let's see what happens if we forget about that.

Exercise

Look at the template. It's essentially the first example query from the previous section, but we removed the termination check. Try to run the query and find out for yourself what happens when the recursion never stops.

Click I'm done. Next exercise when you finish the exercise.