如何使用hierarchyid sql显示所有递归结果
我有一张桌子
categories
ID | NAME | PARENT ID | POSITION | LEVEL | ORDER
----------------------------------------------------------------------------
1 | root | -1 | 0x | 0 | 255
2 | cars | 1 | 0x58 | 1 | 10
5 | trucks | 1 | 0x68 | 1 | 10
13 | city cars | 2 | 0x5AC0 | 2 | 255
14 | offroad cars | 2 | 0x5B40 | 2 | 255
ID int ident
NAME nvarchar(255)
PARENT ID int
POSITION hierarchyid
LEVEL hierarchyid GetLevel()
ORDER tinyint
model
ID | NAME | CATEGORY
-----------------------------
1 | Civic | 13
2 | Pajero | 14
3 | 815 | 5
4 | Avensis | 13
ID int ident
NAME nvarchar(255)
CATEGORY int link to ID category table
cars
没有找到相关结果
已邀请:
2 个回复
娜拐赐巫潭
昧伎
declare @id hierarchyid select @id = Position from Categories where Name = 'root' -- or 'cars', 'city cars', etc. select m.* from Models m join Categories c on m.Category = c.ID where c.Position.IsDescendantOf(@id) = 1方法和其他方法的更多信息，请查看方法参考。