用存储过程实现根据任意给定节点ID值在数据库中查询出其最底层根节点的ID
表结构为id,pid 结构
CREATE PROCEDURE TreePid @id INT AS
declare @pid int
begin
select @pid=pid from treetest where id = @id;
if @pid >0
begin
exec treepid @id = @pid
end
else
begin
select 'result'=@id;
end
end
GO
总结:不用考虑树结构层次,最多实现32层(sqlserver限制)递归