《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