Startsida
Hjälp
Sök i LIBRIS databas

     

 

Sökning: onr:11684154 > Transact-SQL Cookbook

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.)
  • E-bok
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. 

Bibliotek i Stockholmsregionen (1)

Ange som favorit

Bibliotek i västra Sverige (2)

Ange som favorit

Bibliotek i södra Sverige (2)

Ange som favorit

Sök utanför LIBRIS

Hjälp
Om LIBRIS
Sekretess
Hjälp
Fel i posten?
Kontakt
Teknik och format
Sök utifrån
Sökrutor
Plug-ins
Bookmarklet
Anpassa
Textstorlek
Kontrast
Vyer
LIBRIS söktjänster
SwePub
Uppsök

Kungliga biblioteket hanterar dina personuppgifter i enlighet med EU:s dataskyddsförordning (2018), GDPR. Läs mer om hur det funkar här.
Så här hanterar KB dina uppgifter vid användning av denna tjänst.

Copyright © LIBRIS - Nationella bibliotekssystem

 
pil uppåt Stäng

Kopiera och spara länken för att återkomma till aktuell vy