spAddUpdate_ContactGroup

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientUsersID	int	IN
@Name	nvarchar(50)	IN

Definition

Copy




CREATE PROCEDURE [dbo].[spAddUpdate_ContactGroup]
(

    @PKID int output,
    @ClientUsersID int, 
    @Name nvarchar(50)

)
    AS
    BEGIN


        IF (@PKID<=0) 
        BEGIN
            INSERT INTO [ContactGroup]
            (
            ClientUsersID , 
            Name
            )
            VALUES
            (
            @ClientUsersID , 
            @Name
            )

            SELECT @PKID = @@Identity

        END
        ELSE 

            UPDATE [ContactGroup] SET
            ClientUsersID = @ClientUsersID, 
            Name = @Name,
            UpdateDate = getutcdate()
            WHERE [ID]=@PKID

    END