USP_RECORDOPERATION_RESCHEDULETICKETSINCREASECAPACITYFORPROGRAMEVENT

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@CAPACITYINCREASE int IN

Definition

Copy


CREATE procedure dbo.USP_RECORDOPERATION_RESCHEDULETICKETSINCREASECAPACITYFORPROGRAMEVENT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CAPACITYINCREASE int
)
as begin
    update dbo.EVENT set CAPACITY += @CAPACITYINCREASE where ID = @ID;
    return 0;
end