spUpdateEmailList_UpdateRefresh

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Status	int	IN
@StatusReport	ntext	IN
@AcquiredRecordCount	int	IN
@AcquiredDate	datetime	IN

Definition

Copy




CREATE PROCEDURE dbo.spUpdateEmailList_UpdateRefresh
(
        @PKID int OUTPUT,
    @Status int,
    @StatusReport ntext,
    @AcquiredRecordCount int,
  @AcquiredDate datetime
)
AS

DECLARE @hResult int  
SET @hResult = 0

BEGIN TRANSACTION

IF (@PKID<=0) 
    BEGIN
        SET @hResult = -1
    END 
ELSE 
    BEGIN
        UPDATE [dbo].EmailList
        SET
            [AcquiredStatus]=@Status,
            [AcquiredMsg]=@StatusReport,
            [AcquiredRecordCount]=@AcquiredRecordCount,
      [AcquiredDate] = @AcquiredDate
        WHERE ID=@PKID
        IF (@@ERROR <> 0) SET @hResult = @@ERROR
END

COMMIT TRANSACTION
RETURN @hResult