Robin Dewson, Louis Davidson, Tony Bain, Chuck Hawkins

SQL Server 2000 Stored Procedures Handbook (eBook, PDF)

• Format: PDF

Produktbeschreibung

Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any 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 how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 288
• Erscheinungstermin: 9. November 2013
• Englisch
• ISBN-13: 9781430211259
• Artikelnr.: 44041720

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.