存储过程递归调用 拜请高手指教
alter procedure niubin_IsAccountHasChild --- 判断是否有 字节点
(
@FAccountID integer,
@FRootID integer
)
as
Select * from t_Account where FParentID =@FAccountID and FRootID = @FRootID
if @@RowCount > 0
return 1
else
return 0
go
Alter procedure niubin_GetChild
(@FRootID int,
@FAccountID int
)
as
declare MyCursor cursor scroll for
Select FAccountID from t_Account where FParentID =@FAccountID and FRootID = @FRootID
open MyCursor
declare @FAccountIDTemp sysname
declare @IsHasChild int
fetch next from MyCursor into @FAccountIDTemp
while(@@fetch_status=0)
begin
Exec @IsHasChild = niubin_IsAccountHasChild @FAccountIDTemp, 1004--- 判断是否有 字节点 这里也不知道对不
if @IsHasChild = 1
Exec niubin_GetChild 1004, @FAccountIDTemp ---如果有字节点 继续判断字节点(在此调用存储过程本身不知道对不)
else
print @FAccountIDTemp ---如果没有则打印 出该字节点
fetch next from MyCursor into @FAccountIDTemp
end
close MyCursor
deallocate MyCursor
Exec niubin_GetChild 1004, 1007
[解决办法]
顶
