spAddUpdate_Chapters

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(40)	IN
@ChapterSiteID	int	IN
@MemberEmailListID	int	IN

Definition

Copy



CREATE           PROCEDURE dbo.spAddUpdate_Chapters
        (
            @PKID            int output,
            @Name            nvarchar(40),
            @ChapterSiteID         int,
            @MemberEmailListID     int
            )
        AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO Chapters
        (
            [Name],
            [ChapterSiteID],
            [MemberEmailListID]
        )VALUES(
            @Name,
            @ChapterSiteID,
            @MemberEmailListID
        )

        SELECT
            @PKID = @@Identity

        end 
    else 
        begin
            UPDATE Chapters SET
                [Name]            = @Name,
                [ChapterSiteID]     = @ChapterSiteID,
                [MemberEmailListID]     = @MemberEmailListID
            WHERE ID=@PKID
        end
    commit transaction