Transact-SQL Cookbook |
By Jonathan Gennick, Ales Spetic |
|
Publisher | : O'Reilly |
Pub Date | : March 2002 |
ISBN | : 1-56592-756-7 |
Pages | : 302 |
Slots | : 1 | | | Copyright |
| | Dedication |
| | Preface |
| | | Why We Wrote This Book |
| | | Audience for This Book |
| | | Which Platform and Version? |
| | | Structure of This Book |
| | | Conventions Used in This Book |
| | | About the Code |
| | | Comments and Questions |
| | | Acknowledgments |
|
| | Chapter 1. Pivot Tables |
| | | Section 1.1. Using a Pivot Table |
|
| | Chapter 2. Sets |
| | | Section 2.1. Introduction |
| | | Section 2.2. The Students Example |
| | | Section 2.3. Implementing Set Difference |
| | | Section 2.4. Comparing Two Sets for Equality |
| | | Section 2.5. Implementing Partial Intersection |
| | | Section 2.6. Implementing Full Intersection |
| | | Section 2.7. Classifying Subsets |
| | | Section 2.8. Summarizing Classes of Sets |
| | | Section 2.9. Aggregating Aggregates |
| | | Section 2.10. Summarizing Aggregated Classes |
| | | Section 2.11. Including Nonaggregated Columns |
| | | Section 2.12. Finding the Top N Values in a Set |
| | | Section 2.13. Reporting the Size of a Set's Complement |
| | | Section 2.14. Finding the Complement of a Set |
| | | Section 2.15. Finding the Complement of a Missing Set |
| | | Section 2.16. Finding Complements of Sets with Different Universes |
| | | Section 2.17. Comparing a Set with Its Universe |
| | | Section 2.18. Dynamic Classification System |
|
| | Chapter 3. Data Structures |
| | | Section 3.1. Types of Data Structures |
| | | Section 3.2. Working Example |
| | | Section 3.3. Finding Regions |
| | | Section 3.4. Reporting Region Boundaries |
| | | Section 3.5. Limiting Region Size |
| | | Section 3.6. Ranking Regions by Size |
| | | Section 3.7. Working with Sequences |
| | | Section 3.8. Working with Runs |
| | | Section 3.9. Cumulative Aggregates in Lists |
| | | Section 3.10. Implementing a Stack |
| | | Section 3.11. Implementing Queues |
| | | Section 3.12. Implementing Priority Queues |
| | | Section 3.13. Comparing Two Rows in an Array |
| | | Section 3.14. Printing Matrices and Arrays |
| | | Section 3.15. Transposing a Matrix |
| | | Section 3.16. Calculating a Matrix Trace |
| | | Section 3.17. Comparing Two Matrices for Size |
| | | Section 3.18. Adding and Subtracting Matrices |
| | | Section 3.19. Multiplying Matrices |
|
| | Chapter 4. Hierarchies in SQL |
| | | Section 4.1. Types of Hierarchies |
| | | Section 4.2. Creating a Permission Hierarchy |
| | | |