脚本给一个字段累计

declare updateVehicleStateType_ID_rcursor3 cursor scroll --声明一个游标for SELECT ID,VehicleStateType_ID FROM EMTinCar where VehicleStateType_ID=3OPEN updateVehicleStateType_ID_rcursor3   --打开游标DECLARE @ID int , @VehicleOrder_ID int ,@VehicleStateType_ID intset @VehicleOrder_ID=1fetch First from updateVehicleStateType_ID_rcursor3 into @ID ,@VehicleStateType_ID     --into的变量数量必须与游标查询结果集的列数相同WHILE @@fetch_status=0  --提取成功，进行下一条数据的提取操作 beginUpdate EMTinCar Set VehicleOrder_ID=@VehicleOrder_ID Where ID=@ID --修改当前行set @VehicleOrder_ID=@VehicleOrder_ID+1fetch next from updateVehicleStateType_ID_rcursor3 into @ID ,@VehicleStateType_ID      --移动游标endCLOSE updateVehicleStateType_ID_rcursor3DEALLOCATE updateVehicleStateType_ID_rcursor3

--替换之前把之前的排序+1ALTER PROC Up_EMTinCarinfo @VehicleStateType_ID int, --车辆状态 @VehicleOrder_ID1 int,--选中节点的排序 @VehicleOrder_ID2 int --落下的节点的排序AS declare  up_EMTinCarinfo_cursor  cursor scroll for --结果集SELECT ID,VehicleOrder_ID FROM EMTinCar where VehicleStateType_ID =3 and VehicleOrder_ID >=@VehicleOrder_ID2  AND  VehicleOrder_ID<@VehicleOrder_ID1open up_EMTinCarinfo_cursordeclare @ID int ,@VehicleOrder_ID intfetch First from up_EMTinCarinfo_cursor into @ID ,@VehicleOrder_ID    WHILE @@fetch_status=0 begin Update EMTinCar Set VehicleOrder_ID=@VehicleOrder_ID+1 Where ID=@ID --set @VehicleOrder_ID=@VehicleOrder_ID+1fetch next from up_EMTinCarinfo_cursor into @ID ,@VehicleOrder_ID      endCLOSE up_EMTinCarinfo_cursorDEALLOCATE up_EMTinCarinfo_cursor

--替换之前把之前的排序-1ALTER PROC Up_EMTinCarinfo1 @VehicleStateType_ID int, --车辆状态 @VehicleOrder_ID1 int,--选中节点的排序 @VehicleOrder_ID2 int --落下的节点的排序AS declare  up_EMTinCarinfo_cursor1  cursor scroll for --结果集SELECT ID,VehicleOrder_ID FROM EMTinCar where VehicleStateType_ID =3 and VehicleOrder_ID >@VehicleOrder_ID1  AND  VehicleOrder_ID<=@VehicleOrder_ID2open up_EMTinCarinfo_cursor1declare @ID int ,@VehicleOrder_ID intfetch First from up_EMTinCarinfo_cursor1 into @ID ,@VehicleOrder_ID    WHILE @@fetch_status=0 begin Update EMTinCar Set VehicleOrder_ID=@VehicleOrder_ID-1 Where ID=@ID fetch next from up_EMTinCarinfo_cursor1 into @ID ,@VehicleOrder_ID      endCLOSE up_EMTinCarinfo_cursor1DEALLOCATE up_EMTinCarinfo_cursor1