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:

• Creating a Table Using the hierarchyid Data Type

• Populating a Hierarchical Table Using Hierarchical Methods

• Querying a Hierarchical Table Using Hierarchy Methods

• Reordering Data in a Hierarchical Table Using Hierarchical Methods

• Summary: Managing Data in a Hierarchical Table

Next Task in Lesson

Creating a Table Using the hierarchyid Data Type

See Also

Concepts

Lesson 1: Converting a Table to a Hierarchical Structure