could use Node for the HierarchyID

来源: 2009-12-15 15:58:10 [博客] [旧帖] [给我悄悄话] 本文已被阅读:

could use Node for the HierarchyID: parent and child.

sql 2k8 can handle it.

sample:
declare @parent HIERARCHYID = HIERARCHYID::GetRoot()