Export (0) Print
Expand All

Summary: Converting a Table to a Hierarchical Structure

The hierarchyid data type can store a hierarchical relationship in a simple, compact format. Proper indexes can efficiently return data by the level of the hierarchy, by sub-trees of the hierarchy, or by traditional singleton lookups.

In this lesson, you used two of the hierarchical methods. The next lesson will demonstrate how to use more of these methods to query and manipulate the hierarchical data.

Community Additions

ADD
Show:
© 2014 Microsoft