Transact-SQL Cookbook
Transact-SQL Cookbook
ISBN: 1565927567
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 152
Pages: 152
Authors: Ales Spetic, Jonathan Gennick
- Cover
- Table of Contents
- 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
- Section 4.3. Changing Individual Permissions
- Section 4.4. Adding New Individual Permissions
- Section 4.5. Centralizing Authorization Logic
- Section 4.6. Implementing General Hierarchies
- Section 4.7. Traversing Hierarchies Recursively
- Section 4.8. Manipulating Hierarchies Recursively
- Section 4.9. Aggregating Hierarchies
- Section 4.10. Preparing Multilevel Operations
- Section 4.11. Aggregating Hierarchies Revised
- Chapter 5. Temporal Data
- Section 5.1. Introduction
- Section 5.2. The Schedules Example
- Section 5.3. Enforcing Granularity Rules
- Section 5.4. Storing Out-of-Range Temporal Values
- Section 5.5. Deriving the First and Last Dates of the Month
- Section 5.6. Printing Calendars
- Section 5.7. Calculating Durations
- Section 5.8. Reporting Durations
- Section 5.9. Querying Periods
- Section 5.10. Querying Periods and Respecting Granularity
- Section 5.11. Finding Available Periods
- Section 5.12. Finding Common Available Periods
- Section 5.13. Excluding Recurrent Events
- Section 5.14. Excluding Nonrecurring Events
- Section 5.15. Finding Continuous Periods
- Section 5.16. Using Calendar Information with Periods
- Section 5.17. Using Calendar Information with Durations
- Chapter 6. Audit Logging
- Section 6.1. Audit Logs
- Section 6.2. The Warehouse Example
- Section 6.3. Row-Level Logging
- Section 6.4. Reporting Log Events
- Section 6.5. Generating Current Snapshots
- Section 6.6. Generating Time-Restricted Snapshots
- Section 6.7. Undoing Table Changes
- Section 6.8. Minimizing Audit-Log Space Consumption
- Section 6.9. Online Account Balancing
- Section 6.10. Activity-Level Logging
- Section 6.11. Partitioning Large Log Tables
- Section 6.12. Server Push
- Chapter 7. Importing and Transforming Data
- Section 7.1. Considerations When Importing Data
- Section 7.2. Working Examples
- Section 7.3. Importing External Data
- Section 7.4. Importing Data into a Live System
- Section 7.5. Importing with a Single Procedure
- Section 7.6. Hiding the Import Procedure
- Section 7.7. Folding Tables
- Section 7.8. Pivoting Tables
- Section 7.9. Joining Arrays with Tables
- Section 7.10. Joining Arrays with Master Tables
- Section 7.11. Joining Arrays with Multiple Master Records
- Section 7.12. Extracting Master Records from Tables
- Section 7.13. Generating Master Records Online
- Section 7.14. Working with Duplicates
- Chapter 8. Statistics in SQL
- Section 8.1. Statistical Concepts
- Section 8.2. The Light-Bulb Factory Example
- Section 8.3. Calculating a Mean
- Section 8.4. Calculating a Mode
- Section 8.5. Calculating a Median
- Section 8.6. Calculating Standard Deviation, Variance, and Standard Error
- Section 8.7. Building Confidence Intervals
- Section 8.8. Calculating Correlation
- Section 8.9. Exploring Patterns with Autocorrelation
- Section 8.10. Using a Simple Moving Average
- Section 8.11. Extending Moving Averages
- Appendix A. The T-Distribution Table
- Colophon
- Index
- SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
Transact-SQL Cookbook
ISBN: 1565927567
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 152
Pages: 152
Authors: Ales Spetic, Jonathan Gennick