Robin Dewson, Louis Davidson, Tony Bain

SQL Server 2000 Stored Procedures Handbook

Mitwirkender: Bain, Tony; Dewson, Robin; Davidson, Louis

• Broschiertes Buch

Produktbeschreibung

* Shows you how to write more effective stored procedures and functions
* Concise, detailed advice from SQL Server experts
* Tackles issues barely covered in existing books, such as optimizing and debugging, concurrency and transactions.

---

Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.

This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

Produktdetails

• Verlag: Apress
• Artikelnr. des Verlages: 978-1-59059-287-8
• Softcover reprint of the original 1st ed.
• Seitenzahl: 288
• Erscheinungstermin: 29. September 2003
• Englisch
• Abmessung: 235mm x 191mm x 16mm
• Gewicht: 510g
• ISBN-13: 9781590592878
• ISBN-10: 1590592875
• Artikelnr.: 12350566

Autorenporträt

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Inhaltsangabe

1: Stored Procedures Overview.- 2: Optimizing and Debugging.- 3: Concurrency, Cursors, and Transactions.- 4: Common Practices with Stored Procedures.- 5: System Stored Procedures.- 6: User Defined Functions.- 7: Triggers.- 8: Security.- Appendix A: Support, Errata, and forums.apress.com.- Customer Support.- Errata.- The Peer-to-Peer Forums at forums.apress.com.