Microsoft introduced the
HIERARCHYID datatype as part of SQL Server 2008. A
HIERARCHYID instance represents a hierarchy tree structure. Each node of a hierarchy tree can be manipulated and retrieved from the
HIERARCHYID instance. When using
HIERARCHYID, access is provided via a managed set of Common Language Runtime (CLR) data type methods that support creating, reading, updating, and deleting (CRUD) nodes in a hierarchy. An employee dimension, usually modeled as a self-referencing parent-child dimension, is a good candidate for
In the following sections, you will create an employee table, ...