Lesson 2: Creating and Managing Data in a Hierarchical Table


Applies To: SQL Server 2016

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

Lesson 1: Converting a Table to a Hierarchical Structure

Community Additions