spAddUpdate_AnonymousNewsletterPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ContentID	int	IN
@Title	nvarchar(255)	IN
@NewsletterID	int	IN
@AfterUpdatePageID	int	IN

Definition

Copy



CREATE PROCEDURE dbo.spAddUpdate_AnonymousNewsletterPart
    (
    @PKID            int output,
    @ContentID        int,
    @Title            nvarchar(255),
    @NewsletterID        int,
    @AfterUpdatePageID    int
    )
AS
BEGIN
    IF EXISTS(SELECT ContentID FROM AnonymousNewsletterPart WHERE ContentID = @ContentID)
        UPDATE AnonymousNewsletterPart
        SET
            Title            = @Title,
            NewsletterId        = @NewsletterID,
            AfterUpdatePageID    = @AfterUpdatePageID
        WHERE ContentID            = @ContentID
    ELSE
        INSERT INTO AnonymousNewsletterPart
        (
            ContentId,
            Title, 
            NewsletterID,
            AfterUpdatePageID
        )
        VALUES
        (
            @ContentID,
            @Title,
            @NewsletterID,
            @AfterUpdatePageID
        )

    SELECT @PKID = @ContentID
END