Category: Intermediate

SELECT, Deconstructed

Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing About SELECT blog. We’re looking at the SELECT statement clauses in the order that the SQL engine logically processes them…we’ll even write it that way – it’ll look weird, but we’ll be reading it like […]

N Things Worth Knowing About CTEs

Edit: This post was originally published on August 26, 2010. If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) – new in SQL Server 2005 – are actualy pretty #awesomesauce. A CTE is, in essence, a temporary view attached to your SELECT statement.  They’re good for a number of uses, […]

N Things Worth Knowing About SELECT

SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the most complicated structures available to us.  Here are a few things worth knowing about it, from the basic to the obscure.  More-or-Less Basic Structure There’s tons more that can go into the SELECT statement, of course, but the basic structure is:  WITH […]