如果parentID为null,那么我希望用另一个parentName复制它的父级和子级(我将使用替换关键字)。create table #Table(ID int primary key , Name varchar(10),ParentID int )
select 1'John', 1select 4,'Kumar',3Select 5,'Dale John',3
ID Nam
Public Class Employee Public Property ParentID As Nullable(Of Guid)它不是一棵树,而是一个列表,因此ParentID是唯一的,只能出现一次。如何在Linq中(使用vb.net)按" ParentID“(先清空ParentID)对其进行排序?
where Id in (716,724) DECLARE @Id INT = 15
As Id, [Name], ParentId[Name], ic.ParentId, CodePosition + 1 INNER JOIN cteGetRootID cte ON ic.Id =cte.ParentIdSELECT top 1 Id, [Name] FROM cteGetRootID
OR