A Developer's Guide to SQL Server 2005

最新推荐文章于 2025-08-10 16:21:57 发布

原创最新推荐文章于 2025-08-10 16:21:57 发布 · 602 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #microsoft #transactions #notifications #documentation #triggers

SQL Server 2005 专栏收录该内容

1 篇文章

订阅专栏

本书从Microsoft官方文档出发，深入讲解了SQL Server 2005的关键创新，包括新的数据模型、内置.NET托管、增强的编程能力等方面。书中通过大量实例代码演示如何使用XML数据类型及查询、实现SQL Server 2005的Web服务等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A Developer's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases.

You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.

Key coverage includes:
*Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
*Writing procedures, functions, triggers, and types in .NET languages
*Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax Effectively using the XML data type and XML queries
*Implementing native SQL Server 2005 Web Services
*Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
*Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
*Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

http://rapidshare.com/files/13582379/N0321382188.rar