SQL Server 2000 Advanced Programming Techniques

Author: Dejan Sunderic
Publisher:
Publication Date: 2002-03-01
Features: This is a highly distinctive and rare database professional reference book that introduces advanced programming techniques for SQL Server 2000. The book primarily focuses on stored procedures, centering on the theme of designing high-level, professional database applications and web applications. It comprehensively covers all aspects of designing, writing, executing, managing, debugging, recompiling, encrypting, and deploying stored procedures. Additionally, it introduces techniques required to implement a key application, such as error handling, debugging, and version control. Compared to other SQL Server books that only revolve around Microsoft's pubs and Northwind databases, this book encompasses all SQL Server versions, including MSDE. Its most notable feature is the use of a fictional asset tracking database named Asset for illustration, making it more targeted, practical, and useful. Most chapters include exercises, and the book provides solutions to these exercises at the end. The intended readers of this book are professionals with a basic understanding of databases and familiarity with SQL Server, as well as MCSE and MSDE certification exam candidates. This is a highly distinctive and rare database professional reference book that introduces advanced programming techniques for SQL Server 2000. The book primarily focuses on stored procedures, centering on the theme of designing high-level, professional database applications and web applications, and comprehensively covers all aspects of designing, writing, executing, managing, debugging, recompiling, encrypting, and deploying stored procedures.