Advanced SQL

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

  • Stairway Step

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.

2018-03-21 (first published: )

793 reads

Blogs

How I passed the 70-761 certification exam

By

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Read the latest Blogs

Forums

SSDT is not showing in Visual Studio 2013

By SQL-Learner

My machine is currently installed with SQL Server 2012 and visual studio 2010 shell...

What Write Ahead Logging Is and Why It Matters

By Kendra Little

Comments posted to this topic are about the item What Write Ahead Logging Is...

SSAS Error: Duplicate attribute key found when processing

By aveek22

Comments posted to this topic are about the item SSAS Error: Duplicate attribute key...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers