'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. It 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 applies this foundation toward building T-SQL stored procedures, triggers, views, and functions that solve real business problems.