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 SELECT FROM