Forgotten T-SQL Cheat Sheet

You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!

Yessir, this handy-dandy reference sheet includes the Logical Processing Order of SELECT, shorthand for recursive CTEs and MERGE, the famous list-of-details XML trick, and more! And it’s yours, for only $199.99! FREE

Cheat Sheet Not To Scale


Because we like you.

And because it’s a handy-dandy reference for me, too.  (After all, wasn’t I the one who put together the Absentminded DBA’s Cheat Sheet?)

Happy days!


About Jen McCown

This is my site. Details inside.


  1. […] This post was mentioned on Twitter by Jeremiah Peschka and Jen & Sean McCown, Jen & Sean McCown. Jen & Sean McCown said: Blog: Forgotten T-SQL Cheat Sheet Why? Because we like you. […]

  2. Nicely done…

    …but it would be better if it had the bane of my life, the PIVOT! I always have to take three runs at those!

  3. Neat cheat sheet, however it should have something that explains what certain items do because not only do we forget the syntax, we sometimes forget that we can use some of those instead of far more lengthy and CPU consuming alternatives. Looks like you’ve got to burn the Midnight oil and produce the SQL …er, Sequel.

  4. Well, it’s a cheat sheet…it’s kind of a reminder for after one aquaints oneself with the material at hand. For that, I have a handy-dandy recording of 24HOP :)

  5. […] If you like this, you may also like my Forgotten T-SQL Cheat Sheet, which comes with a blog, the code and the 24HOP session […]

  6. Hello, the link doesn’t work. (404). Would you please fix it or re-upload the file?


  7. In case there’ll be a V2 – the XML fragment (pun ok) should promote the “, type … .value(‘.’)” variant: Less gripes from people that reuse this without thinking and consequently missing their ampersands. And less CPU, too.

  8. […] still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>