"Pro SQL Server 2005 T-SQL and Stored Procedure Programming" is the essential guide to building compelling and dynamic database applications using both T-SQL and .NET CLR languages like Visual Basic 2005 and C# 2005. This book shows you practical stored procedure techniques based on real, successful solutions. If you're a SQL Server professional and want to refine your T-SQL knowledge and incorporate CLR stored procedures and XML into your database solutions, then this is the ideal book for you. This book lays a solid foundation of core T-SQL topics such as proper use of data types, insert/update/delete operations, and control-of-flow statements. Then the book applies this foundation toward building T-SQL stored procedures, triggers, views, and functions that solve real business problems. Since data is frequently received in XML form, author Garth Wells demonstrates the most efficient way to process XML data using T-SQL. He suggests how to handle XML as part of your enterprise solution, and provides expert advice about designing and developing CLR-based stored procedures for complex database complex operations ill-suited for T-SQL. The book also covers query optimization and indexing strategies, so that you can implement optimal solutions.