[AccessD] SQL Server 2008

Gustav Brock Gustav at cactus.dk
Tue Jan 22 10:46:27 CST 2008


Hi all

I have enough to evaluate so I was a bit reluctant to "waste" time on SQL Server 2008 until further.
But then I read about the new DATETIMEOFFSET data type and a Hierarchy Id under "Store Any Information" here:

  http://www.microsoft.com/sql/2008/prodinfo/newfeatures.mspxypes 

<quote>
DATE/TIME: SQL Server 2008 introduces new date and time data types:

  DATE * a date only type
  TIME * a time only type
  DATETIMEOFFSET * a time zone aware datetime type
  DATETIME2 * a datetime type w/ larger fractional seconds and year range than the existing DATETIME type

The new data types enable applications to have separate data and time types while providing large data ranges or user defined precision for time values. 

HIERARCHY ID: Enable database applications to model tree structures in a more efficient way than currently possible. New system type, HierarchyId, can store values that represent nodes in a hierarchy tree. This new type will be implemented as a CLR UDT, and will expose several efficient and useful built-in methods for creating and operating on hierarchy nodes with a flexible programming model. 
</quote>

That looks tempting indeed.

/gustav





More information about the AccessD mailing list