Handling Graphs, Trees, and Hierarchies in Microsoft SQL Server

Download this episode

Download Video


Graphs are specialized data structures that represent relationships between pairs of items. Examples for graphs include an Employee Organizational Chart and a Bill of Materials. This session explains how to query graph data stored in SQL Server to answer common requests, including: Subgraph, e.g., return all subordinates of a given manager. Path, e.g., return all management chain of a given employee. Presentation, e.g., sort employees such that a subordinate would be returned after a manager. This session explains how to handle such requests with recursive queries in SQL Server 2005 and also with the new HIERARCHYID datatype introduced in SQL Server 2008.
For more information, check out this course on Microsoft Virtual Academy:







Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.