Programming Microsoft SQL Server 2005

Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions. Discover how to: * Program views, stored procedures, triggers, and functions using T-SQL * Work with the new XML data type and XQuery method * Automate common administration and maintenance tasks * Debug databases, reports, and objects using Microsoft Visual Studio 2005 * Write transactional code and implement local and distributed transactions * Develop mobile data applications using SQL Server 2005 Everywhere Edition * Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users * Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components * PLUS-Get C# code samples on the Web