有一个5级菜单,如
id parantID name link Level
1 0 A 0
2 1 A1 1
6 2 A3 2
7 6 A4 3
8 7 A5 4我现在已经获得A5的ID 8, 如何获得A的ID 1 ???????如果用存储过程,如何实现?
如果不用存储过程呢,哪个好??????
id parantID name link Level
1 0 A 0
2 1 A1 1
6 2 A3 2
7 6 A4 3
8 7 A5 4我现在已经获得A5的ID 8, 如何获得A的ID 1 ???????如果用存储过程,如何实现?
如果不用存储过程呢,哪个好??????
http://community.csdn.net/Expert/TopicView.asp?id=5055818
输入两个参数,部门ID和部门的Level, 获得Level这一层这个记录的IDCREATE PROCEDURE sp_JimProc_GetComID
@ID int,
@ItemLevel int,
@aimID int output
AS
declare @swapLevel int
declare @Parentid intselect @swapLevel=Level,@Parantid=Parantid from Admin_Department where ID=@ID
set @aimID=@Parantid
while @swapLevel > @ItemLevel
begin
select @swapLevel=Level,@Parantid=Parantid from Admin_Department where ID=@Parentid
set @aimID=@Parantid
end