SQL Server2005有关开发的重要特点

SQL Server2005对于软件开发有哪些好的特点呢？高手能不能给介绍一下。

最近比较关注SQL Server2005 还请DX们多多指点！

SQL Server2005对于开发的好处多多，我觉得最重要的就是它与.NET框架整合，使用SQL Server 2005，开发人员通过使用相似的语言，例如微软的Visual C# .NET和微软的Visual Basic，将能够创立数据库对象。开发人员还将能够建立两个新的对象——用户定义的类和集合。另外它对XML技术的良好支持也很有利于现在的软件开发，在使用本地网络和互联网的情况下，在不同应用软件之间散步数据的时候，可扩展标记语言（XML）是一个重要的标准。SQL Server 2005将会自身支持存储和查询可扩展标记语言文件。

我觉得SQL Server 2005新增的SQL服务中介将为大型、营业范围内的应用软件，提供一个分布式的、异步应用框架。SQL Server 2005的通告服务也不错，它使得业务可以建立丰富的通知应用软件，向任何设备，提供个人化的和及时的信息，例如股市警报、新闻订阅、包裹递送警报、航空公司票价等。在SQL Server 2005中，通告服务和其他技术更加紧密地融合在了一起，这些技术包括分析服务、SQL Server Management Studio。

还有Web服务的支持也挺好的，这样就能够在数据库层开发Web服务，将SQL Server当作一个超文本传输协议（HTTP）侦听器，并且为网络服务中心应用软件提供一个新型的数据存取功能。

楼上统统是高人啊，拜了

呵呵，楼上说的不错，我来补充一些。SQL Server 2005还增加了增强性能的Transact-SQL，SQL Server 2005为开发可升级的数据库应用软件，提供了新的语言功能。这些增强的性能包括处理错误、递归查询功能、关系运算符PIVOT, APPLY, ROW_NUMBER和其他数据列排行功能，等等。

自己整理的 sql server 经典电子书 免费下载

[list][*][url=http://www.51cnnet.com/ebook/1222-programming-sql-server-2005]Programming SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1495-portable-dba-sql-server]Portable DBA: SQL Server free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1213-advanced-transact-sql-for-sql-server-2000]Advanced Transact-SQL for SQL Server 2000 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/402-sql-server-2005-reporting-essentials]SQL Server 2005 Reporting Essentials free ebook download[/url][*][url=http://www.51cnnet.com/ebook/429-expert-sql-server-2005-integration-services]Expert SQL Server 2005 Integration Services free ebook download[/url][*][url=http://www.51cnnet.com/ebook/502-pro-sql-server-2005-service-broker]Pro SQL Server 2005 Service Broker free ebook download[/url][*][url=http://www.51cnnet.com/ebook/505-foundations-of-sql-server-2005-business-intelligence]Foundations of SQL Server 2005 Business Intelligence free ebook download[/url][*][url=http://www.51cnnet.com/ebook/521-pro-sql-server-2005-replication]Pro SQL Server 2005 Replication free ebook download[/url][*][url=http://www.51cnnet.com/ebook/691-pro-sql-server-2005-assemblies]Pro SQL Server 2005 Assemblies free ebook download[/url][*][url=http://www.51cnnet.com/ebook/995-beginning-sql-server-2005-for-developers]Beginning SQL Server 2005 for Developers free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1040-sql-server-2000-stored-procedures-handbook]SQL Server 2000 Stored Procedures Handbook free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1324-data-mining-with-sql-server-2005]Data Mining with SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1376-how-to-cheat-at-securing-sql-server-2005]How to Cheat at Securing SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1419-pro-sql-server-disaster-recovery]Pro SQL Server Disaster Recovery free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1446-the-guru-s-guide-to-sql-server-architecture-and-internals]The Guru's Guide to SQL Server Architecture and Internals   free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1477-sql-server-security-distilled-second-edition]SQL Server Security Distilled, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1537-microsoft-sql-server-2000-high-availability]Microsoft SQL Server 2000 High Availability free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1539-sql-server-2000-for-experienced-dbas]SQL Server 2000 for Experienced DBAs free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1541-inside-microsoft-sql-server-2000]Inside Microsoft SQL Server 2000 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1597-microsoft-sql-server-2000-reporting-services]Microsoft SQL Server 2000 Reporting Services[/url][*][url=http://www.51cnnet.com/ebook/1727-a-developer-s-guide-to-sql-server-2005]A Developer's Guide to SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1728-administrator-s-guide-to-sql-server-2005]Administrator's Guide to SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/497-mastering-sql-server-2005-reporting-services-infrastructure-design]Mastering SQL Server 2005 Reporting Services Infrastructure Design free ebook download[/url][*][url=http://www.51cnnet.com/ebook/997-beginning-sql-server-2005-express-for-developers-from-novice-to-professional]Beginning SQL Server 2005 Express for Developers: From Novice to Professional free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1122-pro-vs-2005-reporting-using-sql-server-and-crystal-reports]Pro VS 2005 Reporting Using SQL Server And Crystal Reports free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1435-microsoft-sql-server-2000-a-guide-to-enhancements-and-new-features]Microsoft SQL Server 2000: A Guide to Enhancements and New Features free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1513-pro-sql-server-2005-database-design-and-optimization]Pro SQL Server 2005 Database Design and Optimization free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1568-sql-server-2000-stored-procedure-and-xml-programming-second-edition]SQL Server 2000 Stored Procedure and XML Programming, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1608-microsoft-sql-server-2000-dts-step-by-step]Microsoft SQL Server 2000 DTS Step by Step free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1722-microsoft-sql-server-2000-performance-optimization-and-tuning-handbook]Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1775-microsoft-sql-server-2000-unleashed-second-edition]Microsoft SQL Server 2000 Unleashed, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/426-microsoft-sql-server-2005-stored-procedure-programming-in-t-sql-and-net-third-edition]Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET, Third Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/425-the-microsoft-data-warehouse-toolkit-with-sql-server-2005-and-the-microsoft-business-intelligence-toolset]The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1126-pro-asp-net-for-sql-server-high-performance-data-access-for-web-developers]Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1747-relational-database-index-design-and-the-optimizers-db2-oracle-sql-server-et-al]Relational Database Index Design and the Optimizers DB2, Oracle, SQL Server, et al. free ebook download[/url][/list]

自己整理的 sql server 经典电子书 免费下载

[list][*][url=http://www.51cnnet.com/ebook/1222-programming-sql-server-2005]Programming SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1495-portable-dba-sql-server]Portable DBA: SQL Server free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1213-advanced-transact-sql-for-sql-server-2000]Advanced Transact-SQL for SQL Server 2000 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/402-sql-server-2005-reporting-essentials]SQL Server 2005 Reporting Essentials free ebook download[/url][*][url=http://www.51cnnet.com/ebook/429-expert-sql-server-2005-integration-services]Expert SQL Server 2005 Integration Services free ebook download[/url][*][url=http://www.51cnnet.com/ebook/502-pro-sql-server-2005-service-broker]Pro SQL Server 2005 Service Broker free ebook download[/url][*][url=http://www.51cnnet.com/ebook/505-foundations-of-sql-server-2005-business-intelligence]Foundations of SQL Server 2005 Business Intelligence free ebook download[/url][*][url=http://www.51cnnet.com/ebook/521-pro-sql-server-2005-replication]Pro SQL Server 2005 Replication free ebook download[/url][*][url=http://www.51cnnet.com/ebook/691-pro-sql-server-2005-assemblies]Pro SQL Server 2005 Assemblies free ebook download[/url][*][url=http://www.51cnnet.com/ebook/995-beginning-sql-server-2005-for-developers]Beginning SQL Server 2005 for Developers free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1040-sql-server-2000-stored-procedures-handbook]SQL Server 2000 Stored Procedures Handbook free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1324-data-mining-with-sql-server-2005]Data Mining with SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1376-how-to-cheat-at-securing-sql-server-2005]How to Cheat at Securing SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1419-pro-sql-server-disaster-recovery]Pro SQL Server Disaster Recovery free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1446-the-guru-s-guide-to-sql-server-architecture-and-internals]The Guru's Guide to SQL Server Architecture and Internals   free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1477-sql-server-security-distilled-second-edition]SQL Server Security Distilled, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1537-microsoft-sql-server-2000-high-availability]Microsoft SQL Server 2000 High Availability free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1539-sql-server-2000-for-experienced-dbas]SQL Server 2000 for Experienced DBAs free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1541-inside-microsoft-sql-server-2000]Inside Microsoft SQL Server 2000 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1597-microsoft-sql-server-2000-reporting-services]Microsoft SQL Server 2000 Reporting Services[/url][*][url=http://www.51cnnet.com/ebook/1727-a-developer-s-guide-to-sql-server-2005]A Developer's Guide to SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1728-administrator-s-guide-to-sql-server-2005]Administrator's Guide to SQL Server 2005 free ebook download[/url][*][url=http://www.51cnnet.com/ebook/497-mastering-sql-server-2005-reporting-services-infrastructure-design]Mastering SQL Server 2005 Reporting Services Infrastructure Design free ebook download[/url][*][url=http://www.51cnnet.com/ebook/997-beginning-sql-server-2005-express-for-developers-from-novice-to-professional]Beginning SQL Server 2005 Express for Developers: From Novice to Professional free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1122-pro-vs-2005-reporting-using-sql-server-and-crystal-reports]Pro VS 2005 Reporting Using SQL Server And Crystal Reports free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1435-microsoft-sql-server-2000-a-guide-to-enhancements-and-new-features]Microsoft SQL Server 2000: A Guide to Enhancements and New Features free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1513-pro-sql-server-2005-database-design-and-optimization]Pro SQL Server 2005 Database Design and Optimization free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1568-sql-server-2000-stored-procedure-and-xml-programming-second-edition]SQL Server 2000 Stored Procedure and XML Programming, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1608-microsoft-sql-server-2000-dts-step-by-step]Microsoft SQL Server 2000 DTS Step by Step free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1722-microsoft-sql-server-2000-performance-optimization-and-tuning-handbook]Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1775-microsoft-sql-server-2000-unleashed-second-edition]Microsoft SQL Server 2000 Unleashed, Second Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/426-microsoft-sql-server-2005-stored-procedure-programming-in-t-sql-and-net-third-edition]Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET, Third Edition free ebook download[/url][*][url=http://www.51cnnet.com/ebook/425-the-microsoft-data-warehouse-toolkit-with-sql-server-2005-and-the-microsoft-business-intelligence-toolset]The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1126-pro-asp-net-for-sql-server-high-performance-data-access-for-web-developers]Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers free ebook download[/url][*][url=http://www.51cnnet.com/ebook/1747-relational-database-index-design-and-the-optimizers-db2-oracle-sql-server-et-al]Relational Database Index Design and the Optimizers DB2, Oracle, SQL Server, et al. free ebook download[/url][/list]