一个sql游标使用例子(二)
Values( @currentTime,
1,
'部门管理员调整积分',
@currentTime,
'次',
'',
-@var_cleanPoint,
@var_userID,
0,
100002,
-@var_currentUserPoint
)
insert PointAdjust(
Remark,
Point,
UserId,
AdjustDate
)
Values( '管理员调整',
-@var_cleanPoint,
@var_userID,
@currentTime
)
-- Update UserInfo
update UserInfo
set Point = @var_currentPoint
where DepartmentId=2
and UserId = @var_userID
print @var_userID
-- Update UserInfo
FETCH NEXT FROM cursor_user
INTO @var_userID, @var_currentUserPoint
end
CLOSE cursor_user
DEALLOCATE cursor_user
commit transaction;
end try
begin catch
print @@TRANCOUNT
-- Rollback any active OR uncommittable transactions before
if @@TRANCOUNT > 0
rollback transaction;
end catch