spAddUpdate_EmailProjectAppeal_Emaillist

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@EmailProjectAppealID	int	IN
@EmailListID	int	IN
@AppealListType	smallint	IN

Definition

Copy



    CREATE PROCEDURE [dbo].spAddUpdate_EmailProjectAppeal_Emaillist
@PKID int output,
@EmailProjectAppealID int,
@EmailListID int,
@AppealListType smallint

as

IF @PKID > 0 
    BEGIN
        UPDATE [dbo].[EmailProjectAppeal_EmailList]
        SET [EmailProjectAppealID] = @EmailProjectAppealID
          ,[EmailListID] = @EmailListID
          ,[AppealListType] = @AppealListType
        WHERE [ID] = @PKID
    END
ELSE
    BEGIN
        INSERT INTO [dbo].[EmailProjectAppeal_EmailList]
               ([EmailProjectAppealID]
               ,[EmailListID]
               ,[AppealListType])
         VALUES
               (@EmailProjectAppealID
               ,@EmailListID
               ,@AppealListType)

        SET @PKID = @@IDENTITY
    END