update Project set Project.ProjectName=a.ProjectName+Project.ProjectName from Project as a,Project where Project.ParentID=a.ID
同表自更新,布布扣,bubuko.com
同表自更新
原文：http://www.cnblogs.com/PeaCode/p/3862267.html
