The 6-Year-Old T-SQL Book That Never Goes Out of Style

 dans Sites anglophones  étiqueté t-sql par

You’ve been working with Microsoft SQL Server for yeeears, and you’re pretty confident that you know how to write a query.

So when I tell you about a book called T-SQL Fundamentals, you’re all, “nah, man, I got this covered.”

You are incorrect.

Sure, the first 5 chapters of the book are about 1-2 table queries, CTEs, subqueries, etc, and you’ve probably got that stuff down cold. But here’s where chapter 6 and 7 go:

UNION, INTERSECT, EXCEPT Windowing functions Pivoting data GROUPING SETS, ROLLUP

And subsequent chapters only get more detailed from there: how to properly modify data with