The Guru's Guide to SQL Server Stored Procedures, Xml, and HTML
Résumé
More than just a catalog of coding tricks and syntax subtleties, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to Transact-SQL, this book teaches that stored procedure development does not occur in a vacuum—it involves a wide variety of skills, subjects, and technologies—and helps the reader become a better software engineer, not just a stored procedure expert.
Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing toadvanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source.
Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming.
The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code.
Theoretically sound, yet immensely practical, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML provides developers with the tools they need to become expert stored procedure programmers and better software engineers.
Contents- Preface.
- Introduction.
- 1. Stored Procedure Primer.
- 2. Suggested Conventions.
- 3. Common Design Patterns.
- 4. Source Code Management.
- 5. Database Design.
- 6. Data Volumes.
- 7. Error Handling.
- 8. Triggers.
- 9. Views.
- 10. User-Defined Functions.
- 11. HTML.
- 12. Introduction to XML.
- 13. XML and SQL Server: HTTP Queries.
- 14. XML and SQL Server: Retrieving Data.
- 15. XML and SQL Server: OPENXML.
- 16. Introduction to .NET.
- 17. Performance Considerations.
- 18. Debugging and Profiling.
- 19. Automation.
- 20. Extended Stored Procedures.
- 21. Administrative Stored Procedures.
- 22. Undocumented Code.
- 23. Arrays.
- 24. Create a Workable Environment.
- 25. Make Small Changes.
- 26. Test Your Work.
- Index.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Addison Wesley |
| Auteur(s) | Ken Henderson |
| Parution | 01/02/2002 |
| Nb. de pages | 774 |
| Format | 18,6 x 23,4 |
| Couverture | Broché |
| Poids | 1200g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780201700466 |
| ISBN13 | 978-0-201-70046-6 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
- Informatique Bases de données Produits SGBD SQL Server
- Informatique Développement d'applications Conception et développement web
- Informatique Développement d'applications Conception et développement web Services Web
- Informatique Développement d'applications Langages HTML
- Informatique Développement d'applications Langages XML
- Informatique Développement d'applications Langages XSLT
- Informatique Développement d'applications Langages ASP.NET
- Informatique Certifications Microsoft
