SELECT NodeId.ToString() AS NodeIdPath, dbo.fnGetFullDisplayPath(NodeId) AS NodeIdDisplayPath,*
FROM FAMILY
WHERE NodeId.GetAncestor(2) =
(SELECT NodeId
FROM FAMILY
WHERE FAMILYId = 11)
ORDER BY NodeLevel, NodeId
GO
NodeIdPath NodeIdDisplayPath NodeId NodeLevel FamilyId Title
/1/1/1/ 爷爷 -> 父亲 -> 长子 -> 长孙 0x5AD6 3 1111 长孙
/1/2/1/ 爷爷 -> 父亲 -> 次子 -> 长女 0x5B56 3 1110 长女
/1/2/2/ 爷爷 -> 父亲 -> 次子 -> 次孙 0x5B5A 3 1113 次孙