TechNet
Export (0) Print
Expand All

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

ADD
Show:
© 2016 Microsoft