Search

Search

Search Tips Tips  Advanced Search Advanced    All    Author   Title   ISBN   Keywords

The Guru's Guide to SQL Server Stored Procedures

Add your own review!

The Guru's Guide to SQL Server Stored Procedures

Author:   Ken Henderson
Publisher:   Pearson Education (US)
ISBN:  

9780201700466


Pages:   800
Publication Date:   27 December 2001
Format:   Paperback
Availability:   To order   Availability explained
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.
RRP $89.95 Quantity:  
Add to Cart

Overview

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.

Full Product Details

Author:   Ken Henderson
Publisher:   Pearson Education (US)
Imprint:   Addison-Wesley Educational Publishers Inc
Dimensions:   Width: 18.70cm , Height: 4.10cm , Length: 23.50cm
Weight:   1.207kg
ISBN:  

9780201700466


ISBN 10:   0201700468
Pages:   800
Publication Date:   27 December 2001
Format:   Paperback
Publisher's Status:   Active
Availability:   To order   Availability explained
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

Table of 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

Reviews

Author Information

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences. 0201700468AB07032003

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions

Find a Book Category

Browse For Books

Shopping Cart

Your cart is empty Shopping Cart

  • Books from Aust., USA & UK
  • Books by the millions!
  • Books shipped worldwide.
  • Books previewed through Google preview.
  • Buy DVDs online - MovieFlix.com.au
  • Buy ebooks from ebookBop
  • Read books Rated & Reviewed by our customers
  • Buy books with confidence from Australia's No.1 online book store.
  • Discount books, audio-books and DVDs.
  • Book prices are GST inclusive
  • An all Australian company.
  • Ship unlimited books per order
  • Premium ship books receipted & insured for $6.95 Aust wide.
  • Read about books & the book industry on our Book Blog
  • Book buying is easy with payment by credit card, AMEX, Diners cheque, money order or BPAY.
  • Member of the Australian Bookseller's Association

DVD MovieFlix.com.au

Books Blog

eBook BOP
Australian Booksellers Association
Payment methods