USP_APPSETTING_ADDORUPDATE

create procedure dbo.USP_APPSETTING_ADDORUPDATE
(
        @NAME nvarchar(100),
        @VALUE nvarchar(1024),
        @CHANGEAGENTID uniqueidentifier
)
            as
                set nocount on;

            if @CHANGEAGENTID is null
             exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            declare @DATE datetime;
            set @DATE = getDate();

            if exists(select 1 from dbo.APPSETTING where NAME = @NAME)
                    update dbo.APPSETTING 
                        set VALUE = @VALUE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @DATE
                    where NAME = @NAME;
            else
                    insert into dbo.APPSETTING
                    (
                        NAME,
                        VALUE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values
                    (
                        @NAME,
                        @VALUE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @DATE,
                        @DATE
                    );