Pro SQL Server 2005 T-SQL Progamming

SQL Server 2005 is a landmark new release of Microsoft's powerful relational database management system for the Windows platform, and one that changes the way architect your data systems and data-driven applications will be built. .NET and XML now play a key role in the SQL Server toolset, although the traditional T-SQL programming language continues to evolve and expand, and remains at the heart of SQL Server programming. Pro SQL Server 2005 T-SQL and Stored Procedure Programming offers developers and administrators an essential guide to building compelling and dynamic database applications using T-SQL, .NET CLR languages such as Visual Basic 2005 and C# 2005, and XML. This book shows you practical stored procedure techniques based on real, successful solutions that the author has implemented. It lays a deep foundation on core T-SQL topics such as proper use of data types, insert/update/delete operations, control-of-flow statements and so on. It then directly applies this knowledge in building T-SQL stored procedures, triggers, view and functions that solve real business problems. It demonstrates how to smoothly handle XML as part of your enterprise solution, and provides expert advice on how to design and develop CLR-based stored procedures for complex operations in the database that are ill-suited to T-SQL. With SQL Server 2005, the database professional will need to refine their T-SQL skills, and expand their skill-set to encompass .NET and XML technologies - this is the book that will allow them to do it. TOC:T-SQL Overview.- Data Types.- Data Definition Language.- DML: SELECT, JOINs, and Control-of-Flow.- DML: Inserting, Updating, and Deleting Data.- Built-In Functions.- User-Defined Functions.- Views.- System Stored Procedures.- Extended Stored Procedures.- User-Defined Stored Procedures.- Handling XML.- CLR Procedures.- Triggers.- Procedures and Triggers by Example.- Query Optimization and Application Performance.