同表自更新

update Project set Project.ProjectName=a.ProjectName+Project.ProjectName
from Project as a,Project where Project.ParentID=a.ID