脚本给一个字段累计

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

--替换之前把之前的排序+1
ALTER 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_ID1
open up_EMTinCarinfo_cursor
declare @ID int ,@VehicleOrder_ID int

fetch 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+1
fetch next from up_EMTinCarinfo_cursor into @ID ,@VehicleOrder_ID      
end
CLOSE up_EMTinCarinfo_cursor
DEALLOCATE up_EMTinCarinfo_cursor

--替换之前把之前的排序-1
ALTER 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_ID2
open up_EMTinCarinfo_cursor1
declare @ID int ,@VehicleOrder_ID int

fetch 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      
end
CLOSE up_EMTinCarinfo_cursor1
DEALLOCATE up_EMTinCarinfo_cursor1