Publisher's Synopsis
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
