Lesson 2: Creating and Managing Data in a Hierarchical Table

In Lesson 1, you modified an existing table to use the hierarchyid data type, and populated the hierarchyid column with the representation of the existing data. In this lesson, you will start with a new table, and insert data by using the hierarchical methods. Then, you will query and manipulate the data by using the hierarchical methods.

This lesson contains the following topics:

Next Task in Lesson

Creating a Table Using the hierarchyid Data Type

See Also

Lesson 1: Converting a Table to a Hierarchical Structure