How Do I: Using the HierarchyID Data Type in SQL Server 2008 to manage data hierarchies?
Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is complex and often onerous.The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues.In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to:Create tables that implement this datatypePopulate the table with data using CTEQuery the table using some of the inherent functions available for the HierarchyID Datatype Presented By: Max Adams | Related Videos |