SQL Server Common Table Expressions
- Buy now
- Learn more
- Discussions
- Lesson 1 – Introduction
- Lesson 2 – What is a CTE?
- Lesson 3 – A CTE Query: Structure and First Examples
- Lesson 4 – CTE versus CURSOR
- Lesson 5 – CTEs and VIEWS
- Lesson 6 – CTEs and DELETE Commands
- Lesson 7 – Passing Tables to Functions (with a CTE Inside)
- Lesson 8 – CTEs and UPDATE Commands
- Lesson 9 – CTEs and Table-Valued Functions (TVFs)
- Lesson 10 – CURSORS and NESTED CURSORS
- Lesson 11 – Summary and Wrap-Up
Homework

INTERMEDIATE TSQL - MODULE 05 - CTE 12-08-2025.sql
M5 Lesson Homework Assignments.sql
M5 HOMEWORK TEMPLATES.sql
M5 HOMEWORK SOLUTIONS.sql
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER DATABASE.SQL
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER TABLES.SQL

Lesson 6 – CTEs and DELETE Commands

Lesson unavailable

Please login to your account or buy the course.