Lesson 2: Creating and Managing Data in a Hierarchical Table
Applies To: SQL Server 2016 Preview
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: