
SQL Server 2000 Stored Procedures Handbook
APress
Published on 29. September 2003
Book
Paperback/Softback
VIII, 288 pages
978-1-59059-287-8 (ISBN)
Description
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.
More details
Edition
First Edition
Language
English
Place of publication
Berkeley
United States
Target group
Popular/general
Illustrations
VIII, 288 p.
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 16 mm
Weight
543 gr
ISBN-13
978-1-59059-287-8 (9781590592878)
DOI
10.1007/978-1-4302-1125-9
Schweitzer Classification
Persons
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.
Content
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.