| |
If you want to write better stored procedures, this is the book for you.This book will tackle realworld 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.This book is for the SQL Server 2000 developer, who wants a book that starts where books like Rob Viera`s Professional SQL Server 2000 Programming finish.This book was written by realworld developers, database designers, and administrators and as such, it tackles realworld problems faced by developers when working with stored procedures, showing you how to solve these problems, and avoiding common pitfalls. In the process of working through this book, you will learn to write more robust stored procedures that execute faster and protect the integrity of your data and the database itself. If you are a database administrator, you will gain valuable insights about expanding on the core system stored procedures to streamline your administration.Topics covered include:Typical uses and misuses of stored proceduresDebugging and optimizing stored proceduresSystem stored procedures and extended stored proceduresCursors, transactions and concurrencyWorking with triggersUser defined functionsStored procedures and security
|
| |
|