Programming Microsoft SQL Server

Essential reference guide to understanding fundamentals of programming SQL Server 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