Flylib.com
Transact-SQL Cookbook
Transact-SQL Cookbook
ISBN: 1565927567
EAN: 2147483647
Year: 2005
Pages: 152
Authors:
Ales Spetic
,
Jonathan Gennick
BUY ON AMAZON
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
Year: 2005
Pages: 152
Authors:
Ales Spetic
,
Jonathan Gennick
BUY ON AMAZON
SQL Tips & Techniques (Miscellaneous)
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Using Keys and Constraints to Maintain Database Integrity
Monitoring and Enhancing MS-SQL Server Performance
Repairing and Maintaining MS-SQL Server Database Files
Writing Advanced Queries and Subqueries
VBScript Programmers Reference
The Scripting Runtime Objects
Regular Expressions
HTML Applications
Appendix A VBScript Functions and Keywords
Appendix K The Variant Subtypes
Junos Cookbook (Cookbooks (OReilly))
Loading a Previous Router Configuration
Logging
Saving Logging Messages to the Other Routing Engine
Moving IS-IS Traffic off a Router
Disabling OSPF on an Interface
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Introduction to Probability and Statistics for Projects
Quantitative Time Management
Special Topics in Quantitative Management
Quantitative Methods in Project Contracts
Programming .Net Windows Applications
Events
Other Basic Controls
PictureBox
TreeView
MonthCalendar
DNS & BIND Cookbook
Configuring a Name Server as a Slave for a Zone
Notifying a Slave Name Server Not in a Zones NS Records
Limiting NOTIFY Messages
Configuring Multiple Mail Servers in DNS
Preventing Windows Computers from Trying to Update Your Zones
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies