Transact-SQL Cookbook [Elektronisk resurs]
-
Spetic, Ales. (författare)
-
Gennick, Jonathan. (författare)
- ISBN 9780596552039
- Publicerad: Sebastopol : O'Reilly Media, Inc. 2009
- Engelska 1 online resource (304 p.)
Innehållsförteckning
Sammanfattning
Ämnesord
Stäng
- Transact-SQL Cookbook; Audience for This Book; Which Platform and Version?; Structure of This Book; Conventions Used in This Book; About the Code; Comments and Questions; Acknowledgments; From Jonathan; 1. Pivot Tables; 1.1.2. Solution; 1.1.3. Discussion; 2. Sets; 2.1.1.2. Elements; 2.1.1.3. Universes; 2.1.2. Set Operations; 2.1.2.2. Intersection; 2.1.2.3. Union; 2.1.2.4. Complement; 2.1.2.5. Difference; 2.2. The Students Example; 2.3. Implementing Set Difference; 2.3.2. Solution; 2.3.2.2. Subtracting one set from all others; 2.3.3. Discussion; 2.3.3.2. Subtracting one set from all others.
- 2.3.3.3. Subtracting other sets from one2.4. Comparing Two Sets for Equality; 2.4.2. Solution; 2.4.3. Discussion; 2.5. Implementing Partial Intersection; 2.5.2. Solution; 2.5.3. Discussion; 2.6. Implementing Full Intersection; 2.6.2. Solution; 2.6.3. Discussion; 2.7. Classifying Subsets; 2.7.2. Solution; 2.7.3. Discussion; 2.8. Summarizing Classes of Sets; 2.8.2. Solution; 2.8.3. Discussion; 2.9. Aggregating Aggregates; 2.9.2. Solution; 2.9.3. Discussion; 2.10. Summarizing Aggregated Classes; 2.10.2. Solution; 2.10.3. Discussion; 2.11. Including Nonaggregated Columns; 2.11.2. Solution.
- 2.11.3. Discussion2.12. Finding the Top N Values in a Set; 2.12.2. Solution; 2.12.3. Discussion; 2.12.3.2. Using a self-join; 2.13. Reporting the Size of a Set&s Complement; 2.13.2. Solution; 2.13.3. Discussion; 2.14. Finding the Complement of a Set; 2.14.2. Solution; 2.14.2.2. Step 2: Run the query; 2.14.3. Discussion; 2.15. Finding the Complement of a Missing Set; 2.15.2. Solution; 2.15.2.2. Solution 2: Create a student master table; 2.15.3. Discussion; 2.16. Finding Complements of Sets with Different Universes; 2.16.2. Solution; 2.16.3. Discussion; 2.17. Comparing a Set with Its Universe.
- 2.17.2. Solution2.17.3. Discussion; 2.18. Dynamic Classification System; 2.18.2. Solution; 2.18.2.2. Step 2: Running the query; 2.18.3. Discussion; 3. Data Structures; 3.1.1.2. Regions; 3.1.1.3. Runs; 3.1.1.4. Sequences; 3.1.2. Stacks and Queues; 3.1.2.2. Queues; 3.1.2.3. Priority queues; 3.1.3. Arrays and Matrices; 3.1.3.2. Matrices; 3.2. Working Example; 3.2.2. Arrays; 3.2.3. Matrices; 3.3. Finding Regions; 3.3.2. Solution; 3.3.3. Discussion; 3.4. Reporting Region Boundaries; 3.4.2. Solution; 3.4.3. Discussion; 3.5. Limiting Region Size; 3.5.2. Solution; 3.5.3. Discussion.
- 3.6. Ranking Regions by Size3.6.2. Solution; 3.6.3. Discussion; 3.7. Working with Sequences; 3.7.2. Solution; 3.7.3. Discussion; 3.8. Working with Runs; 3.8.2. Solutions; 3.8.3. Discussion; 3.9. Cumulative Aggregates in Lists; 3.9.2. Solution; 3.9.3. Discussion; 3.10. Implementing a Stack; 3.10.2. Solution; 3.10.2.2. POP function in SQL; 3.10.2.3. PUSH function in SQL; 3.10.3. Discussion; 3.11. Implementing Queues; 3.11.2. Solution; 3.11.2.2. DEQUEUE function in SQL; 3.11.2.3. ENQUEUE function in SQL; 3.11.3. Discussion; 3.12. Implementing Priority Queues; 3.12.2. Solution.
- 3.12.2.2. DEQUEUE function in SQL.
- This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution. SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQ
Ämnesord
- Cookbooks.
- Relational databases.
- SQL (Computer program language).
Genre
- Electronic books. (LCSH)
Klassifikation
- QA76.73.S67S64 2002 (LCC)
- 005.7565 (DDC)
- Pubdhz (kssb/8 (machine generated))
Inställningar
Hjälp
Titeln finns på 5 bibliotek.
Ange som favorit
-
Kungliga Tekniska högskolan, E-resurser (Tdig)Ange som favorit
-
Bibliotekets lokala katalogTillgång för KTH Biblioteket
-
-
Läs hela (Online access for KTHB) (fulltext) (O'Reilly Learning)
Öppettider, adress m.m.
Ange som favorit
-
Göteborgs universitetsbibliotek, E-resurser (Gdix)Ange som favorit
-
Bibliotekets lokala katalogFind@GU
-
-
Läs hela (Tillgänglig för Göteborgs universitet / Online access for the University of Gothenburg) (O'Reilly Online Learning: Academic/Public Library Edition:Full Text)
Öppettider, adress m.m.
-
Högskolan i Borås, Biblioteket, Digitala resurser (Hibd)Ange som favorit
-
Bibliotekets lokala katalog
-
-
Läs hela (Tillgänglig för användare inom Högskolan i Borås) (fulltext) (O’Reilly eBooks)
Öppettider, adress m.m.
Ange som favorit
-
Blekinge Tekniska Högskola, biblioteket, Digitala resurser (Bthd)Ange som favorit
-
Bibliotekets webbplats
-
-
Läs hela (Online access for BTH) (O'Reilly Online Learning: Academic/Public Library Edition)
Öppettider, adress m.m.
-
Högskolan Kristianstad, E-resurser (KrhE)Ange som favorit
-
Bibliotekets webbplats
-
-
Läs hela (Online access for HKR) (O'Reilly Academic)
Öppettider, adress m.m.