spAddUpdate_ChapterSite

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DisplayName	nvarchar(100)	IN
@SiteContentID	int	IN
@IsFunctional	bit	IN

Definition

Copy



        CREATE    Proc spAddUpdate_ChapterSite
        @PKID int output,
        @DisplayName nvarchar(100),
        @SiteContentID int,
        @IsFunctional bit

        as

        IF @PKID <= 0 
            BEGIN
                INSERT INTO [dbo].[ChapterSite]([SiteContentID],[DisplayName],[IsFunctional])
                VALUES(@SiteContentID, @DisplayName,@IsFunctional)
            SELECT
                    @PKID = @@Identity
            END
        ELSE
            BEGIN
                UPDATE [dbo].[ChapterSite]
                SET [SiteContentID]=@SiteContentID, [DisplayName]=@DisplayName,[IsFunctional] = @IsFunctional
                WHERE [ID] = @PKID
            END