/*初始化堆栈*/
Create Table #stack (item varchar(10),levleN int,pre varchar(10))
Insert into #stack values(@iTargetID,1,'0')
/*levleN 表示的是层数,递归的级数*/
while @levleN > 0
begin
if exists (select * from #stack where levleN = @levleN)
begin
.........................
---删除堆栈中已处理完的数据
delete from #stack where levleN = @levleN and item = @current