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."