SQL Server 2008 -- The hierarchyid Data Type (2)

●The benefit of the hierarchyid Data Type

1.Can invoke methods to arbitrarily(任意的) insert, modify, and delete nodes at any point within the structure very efficiently

2.Can reparent(重新定義父階) entire subtrees in a single update.

3.Faster than running recursive queries on a traditional self-joining table using CTEs.

4.The hierarchyid type is implemented as a SQL common language runtime (CLR) user-defined type (UDT). This means that hierarchyid is hosted internally by the CLR and not natively by SQL Server.