C language function:GetAncestor sample codes

Search sample code in the internet.It is the result.


TITLE : Using the hierarchyid SQL Server Data Type | Tallan's Technology Blog
WHERE NodeId.GetAncestor(1) = @ParentNodeId.......
http://blog.tallan.com/2013/10/24/using-the-hierarchyid-sql-server-data-type/


search Google

https://www.google.com/#q=GetAncestor