How to store one-to-many and many-to-many hierarchical data structures in SQL Server.

There are different ways to handle hierarchical relationships between entities in SQL Server.A good portion of this season will be about the most misunderstood SQL data type, hierarchyid. In the first half, learn how to create and use hierarchyid nodes to retrieve data, and in the second, know Graph Table types which will be available for developers in SQL Server 2017. Here's your chance to become a Pro at creating and querying new Graph tables for many-to-many entity relationships.