SQL 2008 Hierarchy ID
HierarchyID
SQL Server 2008 enables database applications to model tree structures in a more efficient way than currently possible. HierarchyId is a new system type that can store values that represent nodes in a hierarchy tree. This new type features a flexible programming model. It is implemented as a CLR UDT that exposes several efficient and useful built-in methods for creating and operating on hierarchy nodes.