SQL Server 2000 Stored Procedures Handbook

Softcover Nachdruck of the original 1. Auflage 2003
ISBN: 978-1-59059-287-8
Verlag: Apress

Buch, Englisch, 288 Seiten, Paperback, Format (B × H): 191 mm x 235 mm, Gewicht: 543 g

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.

Zielgruppe

Popular/general

Autoren/Hrsg.

Dewson, Robin

Bain, Tony

Hawkins, Chuck

Davidson, Louis

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Prozedurale Programmierung
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation

Inhaltsverzeichnis

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.

Über Autor(innen)

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.