sql - Adventureworks 2005 和 2008

Question

有谁知道这两个数据库有什么区别？我问的原因是我正在上 sql 类(class)，而他们使用的是 2008，但是，由于我安装了 sql server 2005，所以我无法使用 Adventureworks 2008。谢谢您的帮助。

Answer 1

来自官方网站AdventureWorks :

AdventureWorks 2008R2 Details

The following changes have been made in the design of AdventureWorks2008 and AdventureWorks2008R2:

• The way people and businesses are represented has changed. Some tables have been added, renamed, and deleted. These changes enable better integration with the Microsoft ADO.NET Entity Framework.
• New data types and attributes are now demonstrated in the database including:
  • date and time
  • hierarchyid
  • geography
  • filestream
• Integrated full-text support has been incorporated into the database.