Guru's Guide to SQL Server Stored Procedures, XML, and HTML, the

Guru's Guide to SQL Server Stored Procedures, XML, and HTML, the

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 800 p.
  • 言語 ENG
  • 商品コード 9780201700466
  • DDC分類 005.7585

Full Description

SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

Contents

Preface.


Introduction.
I. THE BASICS.

 1. Stored Procedure Primer.
 2. Suggested Conventions.
 3. Common Design Patterns.
 4. Source Code Management.
 5. Database Design.
 6. Data Volumes.
II. OBJECTS.

 7. Error Handling.
 8. Triggers.
 9. Views.
10. User-Defined Functions.
III. HTML, XML, AND .NET.

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.
IV. ADVANCED TOPICS.

17. Performance Considerations.
18. Debugging and Profiling.
19. Automation.
20. Extended Stored Procedures.
21. Administrative Stored Procedures.
22. Undocumented Code.
23. Arrays.
V. ESSAYS ON SOFTWARE ENGINEERING.

24. Create a Workable Environment.
25. Make Small Changes.
26. Test Your Work.
Index. 0201700468T10152001