spAddUpdate_ChapterPages

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DisplayName	nvarchar(100)	IN
@SitePageID	int	IN
@IsHomePage	bit	IN
@ChapterSiteID	int	IN

Definition

Copy



    CREATE  proc dbo.spAddUpdate_ChapterPages
    @PKID int output,
    @DisplayName nvarchar(100),
    @SitePageID int,
    @IsHomePage bit,
    @ChapterSiteID int

    as

    if @PKID <= 0
        BEGIN
            INSERT INTO [dbo].[ChapterPages]([DisplayName], [SitePageID], [IsHomePage], [ChapterSiteID])
            VALUES(@DisplayName, @SitePageID, @IsHomePage, @ChapterSiteID)
            SELECT @PKID = @@Identity
        END
    ELSE
        BEGIN
            UPDATE [dbo].[ChapterPages]
            SET [DisplayName]=@DisplayName, [SitePageID]=@SitePageID, [IsHomePage]=@IsHomePage, [ChapterSiteID]=@ChapterSiteID
            WHERE [ID] = @PKID
        END