If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, "Code Centric: T-SQL Programming with Stored Procedures and Triggers" is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000such as UDFs (user-defined functions)you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

This book teaches stored procedure techniques for SQL Server 2005 based on real-world solutions. It lays a foundation on core T-SQL topics such as proper use of data types, insert/update/delete operations, and more, and applies this knowledge to build functions that solve real business problems. It shows how to smoothly handle XML as part of enterprise solutions, and provides expert advice on design and development of CLR-based stored procedures. With SQL Server 2005, database professionals will need to refine their T-SQL skills, and expand their skill-set to encompass .NET and XML technologies this book teaches them to do it."