USP_GLOBALCHANGE_ADDRECORDCOUNTINFORMATION

Adds a row to the GLOBALCHANGERECORDCOUNT table.

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@NUMBERADDED	int	IN
@NUMBEREDITED	int	IN
@NUMBERDELETED	int	IN

Definition

Copy



            create procedure dbo.USP_GLOBALCHANGE_ADDRECORDCOUNTINFORMATION
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier,
                @NUMBERADDED int = 0,
                @NUMBEREDITED int = 0,
                @NUMBERDELETED int = 0
            )
            as 
            begin
                set nocount on;

                insert into 
                    dbo.GLOBALCHANGERECORDCOUNT (ID, NUMBERADDED, NUMBEREDITED, NUMBERDELETED)
                values
                    (@BUSINESSPROCESSSTATUSID, @NUMBERADDED, @NUMBEREDITED, @NUMBERDELETED);
            end