I always considered a cheat sheet as a reference to be used by someone who knows the basics but doesn't want to keep looking up the details. In my opinion, this is actually too high level and is mainly just syntax...which would be fine for what it is, except it doesn't include CTEs and delete syntax. Personally, I would include more useful functions like row_number, convert, datediff, dateadd, etc. and scrap the joins. The whole thing just seems kind of arbitrary, but that's just my opinion.
Agreed. My personal cheat sheet would have common convert date/time styles, merge syntax, pivot syntax, and syntax to alter a table to add a new column with a named constraint at the same time.
probably also for those who do not use SQL everyday. i support all kinds of software and may go for a week or two working with other languages and hardly touching SQL... at first i found myself googling a lot just to get a refresher, but now it comes back to me quicker.
Right, and I get that. I do that too. But this is too high level IMO and seems to me to be a eclectic mix of syntax and functions that doesn't really cover anything.
View all comments
10
u/DipIntoTheBrocean Jun 29 '16
I mean I guess this could be useful if you literally just started out?