USP_FEATUREGROUPCATALOG_CREATEORUPDATE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@SPECXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SPECUINAME	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_FEATUREGROUPCATALOG_CREATEORUPDATE(@ID uniqueidentifier,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @SPECXML xml,
    @CHANGEAGENTID uniqueidentifier = null,
    @SPECUINAME nvarchar(100) = '')
as
begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    if @SPECUINAME is null
    begin
        set @SPECUINAME = '';
    end;

    if exists(select ID from dbo.FEATUREGROUPCATALOG where ID = @ID)
    begin
        update dbo.FEATUREGROUPCATALOG set 
            NAME = @NAME, 
            DESCRIPTION = @DESCRIPTION, 
            SPECXML = @SPECXML,
            CHANGEDBYID = @CHANGEAGENTID
        where ID = @ID;
    end
    else
    begin
        insert into dbo.FEATUREGROUPCATALOG
        (
            ID,
            NAME,
            DESCRIPTION,
            SPECXML,
            SPECUINAME,
            ADDEDBYID,
            CHANGEDBYID
        )
        values 
        (
            @ID,
            @NAME,
            @DESCRIPTION,
            @SPECXML,
            @SPECUINAME,
            @CHANGEAGENTID,
            @CHANGEAGENTID
        );
    end;

end