sql server 游标 重新排序
Declare @pp int
set @pp=1
DECLARE My_Cursor CURSOR --定义游标
FOR SELECT * FROM tree where parentnodeid='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' order by position desc --查出需要的集合放到游标中
OPEN My_Cursor; --打开游标
FETCH NEXT FROM My_Cursor ; --读取第一行数据
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE tree SET ppp =@pp WHERE CURRENT OF My_Cursor; --更新
--DELETE FROM tree WHERE CURRENT OF My_Cursor; --删除
set @pp=@pp+1
FETCH NEXT FROM My_Cursor; --读取下一行数据
END
CLOSE My_Cursor; --关闭游标
DEALLOCATE My_Cursor; --释放游标
GO