我们平常对TreeView节点的添加，发现位置不对，这样就需要移动，移动就得修改序号，通过传参写sql点击打开链接语句，程序可方便执行
转载请注明出处：飞哥的专栏
[email protected]，@Id为节点的Id,@ParentId为节点的父节点Id,@Flag为移动标志0代表节点上移、1代表下移declare @TempId int,@Id int,@ParentId int,@Flag intbegin set @Id=29 set @ParentId=26 set @Flag=1 if @Flag=0 begin set @TempId=(select top 1 Id from (select Id,Sort from KnowledgeInfo where [email protected]) a where Sort<(select Sort from KnowledgeInfo where [email protected]) order by Sort desc) update KnowledgeInfo set Sort=(select Sort - 1 from KnowledgeInfo where [email protected]) where [email protected] update KnowledgeInfo set Sort=(select Sort + 1 from KnowledgeInfo where [email protected]) where [email protected] end else if @Flag=1 begin set @TempId=(select top 1 Id from (select Id,Sort from KnowledgeInfo where [email protected]) a where Sort>(select Sort from KnowledgeInfo where [email protected]) order by Sort) update KnowledgeInfo set Sort=(select Sort + 1 from KnowledgeInfo where [email protected]) where [email protected] update KnowledgeInfo set Sort=(select Sort - 1 from KnowledgeInfo where [email protected]) where [email protected] endend