Bücher online kaufen
SQL Server 2000 Stored Procedures Handbook
Paperback
Print on Demand | Lieferzeit: Print on Demand - Lieferbar innerhalb von 3-5 Werktagen I
Artikel-Nr:
9781590592878
Veröffentl:
2003
Einband:
Paperback
Erscheinungsdatum:
29.09.2003
Seiten:
288
Autor:
Robin Dewson
Gewicht:
543 g
Format:
235x191x16 mm
Sprache:
Englisch
Beschreibung:
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.
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.
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.
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.