110,539
社区成员
发帖
与我相关
我的任务
分享
declare @id int
declare @parent_id int
set @id=a
set @parent_id=select ParentId from dbo.TableName where id=@id
while (@parent_id is not null)
begin
set @id=@parent_id
set @parent_id=select ParentId from dbo.TableName where id=@id
end
declare @id int
declare @parent_id int
set @id=a
set @parent_id=select ParentId from dbo.TableName where id=@id
while (@parent_id!=null)
begin
set @id=@parent_id
set @parent_id=select ParentId from dbo.TableName where id=@id
end
//result:@id的值
A obj = a;
while(obj.parent != null)
{
obj = obj.parent;
}